Thread: Vlookup Giving #N/A error

Hi,
am trying to lookup the invoice# (B) from sheet 4 to see if and on which date (sheet 5) did this show up on?

I am getting an error when I use the Vlookup formula even though I think have put in the formula accurately.

=VLOOKUP(B2,Sheet5!A:E,5,FALSE)

what seems to be the problem here?

The formula you want, assuming invoice numbers are in column C on sheet5:

=VLOOKUP(B2,Sheet5!$C$1:$E$329,3,FALSE)

Note: most of the invoices haven't been "posted", so those that haven't will return #N/A (not found in data searched).

See attached for a method to avoid the NA ( col F is hidden)