Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two sheets in the same workbook. Master and New.
Masters data will be similar to that of New, EXCEPT, Master will have an additional column of notes, cell H, that is not in sheet New. I need to copy the notes column from sheet Master H to New H But to find the proper row it has to match criteria in 3 cells. Criteria are cells A B and C. So I am thinking, use VLookup for A but how do I also include the AND IFs for B and C. There is no unique field, it has to match 3 fields. Any help is GREATLY appreciated. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup with AND, OR IF statements | Excel Worksheet Functions | |||
VLOOKUP and IF Statements | Excel Discussion (Misc queries) | |||
Using Vlookup with IF statements | Excel Programming | |||
Using Vlookup for IF statements | Excel Programming | |||
Help with Vlookup and If Statements | Excel Discussion (Misc queries) |