Hello everyone, I will really use some help from all you experts in MS Excel..........
I have two tabs
Tab A: Name, Status (Blank), C, D
Tab B: Name, Status, C, D, E
I would like to do a lookup for a TabA:Name in TabB: Name and if matches return value of TabB:Status field in TabA:Status field
I tried something like this but not working:
=IFERROR(VLOOKUP($B2,'New Dom9 Inventory Dump'!B:B,11,FALSE),"No Match")
I have two tabs
Tab A: Name, Status (Blank), C, D
Tab B: Name, Status, C, D, E
I would like to do a lookup for a TabA:Name in TabB: Name and if matches return value of TabB:Status field in TabA:Status field
I tried something like this but not working:
=IFERROR(VLOOKUP($B2,'New Dom9 Inventory Dump'!B:B,11,FALSE),"No Match")