Forum Discussion

Brass Contributor

Nov 10, 2021

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?

Formulas and Functions

OliverScheurich
Nov 10, 2021
rhockman
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?
Vlookup Fail Att.pdf79 KB

OliverScheurich

Gold Contributor

Nov 10, 2021

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?

Vlookup Fail Att.pdf79 KB

rhockman
Brass Contributor
Nov 10, 2021
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
- OliverScheurich
  Gold Contributor
  Nov 10, 2021
  rhockman
  LOOKUP understands that the search column is in ascending order and always looks for an approximate match. If there isn't an exact match, LOOKUP returns the next smaller value. Compare the search value in cell B3 and the return value in E3 in your file as well.
  
  I suggest to apply VLOOKUP (exact match) instead of LOOKUP. You can try the formulas i suggested in my last post.

Resources