| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a VLOOKUP use two items to search
I am trying to look up from a table -
Column 1 Column 2 H 1 H 2 Y 1 Y 2 I want to show in column 3 if Col 1 is H and Column 2 is 1 the Col 3 would be £10 If Col 1 is H and col 2 is 2 then it would be £15? I have a table with all the values for each one in? Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Vlookup with validation | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Banging head against wall with VLOOKUP | Excel Discussion (Misc queries) | |||
| is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
| can vlookup search multiple data tables | Excel Discussion (Misc queries) | |||
Threaded Mode
