| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLOOKUP to locate an answer in one of multiple columns
I am using the following formula to get an answer from a single column of a
spreadsheet (column 2) =VLOOKUP(B3,Master!$R$3:$AP$4180,2,FALSE) Would you please tell me how I should modify the formula to look in more than one column for the appropriate answer? (i.e. look in columns #2, #9, and #22) If possible I would also like the formula to make the answer cell blank if it is unable to locate an appropriate answer. Thanks. Note: I also posted this question in the Applications Errors section by accident... sorry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 columns of data to return an answer (Vlookup???) | Excel Discussion (Misc queries) | |||
| HOW TO LOCATE DUPLICATES ON TWO COLUMNS | Excel Discussion (Misc queries) | |||
| VLOOKUP, IF and multiple columns | Excel Discussion (Misc queries) | |||
| Get Vlookup to look at multiple Rows for the answer | Excel Worksheet Functions | |||
| VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
