Please see the attached file and help me write a formula for what I am looking for?
I need the formula to look within the set of objects in column A on sheet 1 and then find one of those objects in column A on sheet 2 and give me the value from column B on sheet 2 back onto column B of sheet 1.
Thanks!
Test--1.xlsx
Assuming 1 or 0 matches per row this formula should work for B2 copied down
=IFERROR(LOOKUP(2^15,SEARC
.....but as I say that will give you all zeroes for the data "as is". If I change all the "BO"s to "BX"s I get the results you wanted - see attached
regards, barry
Test--1-barry.xlsx