| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with if statement together
I need help to do a vlookup with if statement together
Sheet 1 - Column A: Dates, Column B: Names:, Column C: Control Numbers, Sheet 2 - Column A: Dates, Column B: Names, Column C: Code Numbers, In Column D on sheet 2, I want to see the Control Number for the specific Name and specific Date. This is what I have in D1 =IF(A1=Sheet1!A:A,VLOOKUP(B1,Sheet1!$A$1:$C$100,3) ) Instead of getting the Control Number I get FALSE What am I doing wrong? Can you please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using vlookup within an if statement | Excel Worksheet Functions | |||
| Vlookup with if statement | Excel Discussion (Misc queries) | |||
| If Statement / VLookup | Excel Worksheet Functions | |||
| Vlookup with If Statement | Excel Worksheet Functions | |||
| If Statement with VLookup | Excel Worksheet Functions | |||
Threaded Mode
