| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup formula combining two columns
I'm trying to create a formula that takes into account two columns B & C and
matches those two coloums with two columns from another table in A & B and if those match returns what result is listed in column E. Example below... Book1 B TEST C PASS BOOK2 A TEST B PASS E 100.00 BOOK1 D = BOOK2 column E "100.00" My thought is a "Vlookup" or "If" formula would work, just not sure how to combine the two columns. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining If, Vlookup in formula | Excel Worksheet Functions | |||
| Need help in Combining If formula with Vlookup | Excel Discussion (Misc queries) | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| vlookup or sumproduct formula for 2 columns data validtion | Excel Worksheet Functions | |||
| combining a Vlookup and Mid formula | Excel Worksheet Functions | |||
Threaded Mode
