Forum Discussion
Solved
Lookup
How do I search a longer list on another tab to find the same ID from another month of data and add the Fail and Att data from Oct?
In F5:
=VLOOKUP(E5,$B$2:$D$11,2,FALSE)
In G5:
=VLOOKUP(E5,$B$2:$D$11,3,FALSE)
Are these the formulas you are looking for?
In F5:
=VLOOKUP(E5,$B$2:$D$11,2,FALSE)
In G5:
=VLOOKUP(E5,$B$2:$D$11,3,FALSE)
Are these the formulas you are looking for?
I used the Lookup function and it has one hiccup that I don't understand. The last value in column B is not in the OCT data and it is returning the previous cell data. UGH