#1
|
|||
|
|||
"Vlookup" to search in multiple columns
Hello. I usually use vlookup to search in one column, but I need my function to search in multiple columns. How can I do that.
I usually would use =vlookup(G2,Sheet8!K:L,2,false) but instead of just looking in column K and displaying what is in column L, i need to searching in columns D to K and then display what is in column L. Thank you in advance, |
#2
|
|||
|
|||
Maybe like shown in the attached.
|
#3
|
|||
|
|||
I tried to help you with something you asked for help to.
What about a little reply? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Spreadsheet with "CR" & "DB" in amount & number columns. | bfisher | Excel | 4 | 09-28-2015 07:03 AM |
vlookup yeilds "weird" results... | markjkubicki | Excel | 3 | 05-07-2015 12:54 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |
How do I change the "and" to "or" with multiple Rules (and Alerts)? | bschimmel | Outlook | 0 | 11-16-2009 05:26 AM |