Vlookup problem

[pete4monc]

Hi gents
I am trying to lookup the order number in one spreadsheet (Input Sheet, column B) matching it with the same number on another spreadsheet (CustomerService, column B) and then return the date it was finished on the CustomerService sheet, column J. But it keeps coming up with #N/A and if I put in iferror, it returns nothing?
On both sheets the order numbers are in columns B and the date on the customerservice sheet is in column J
=IFERROR(VLOOKUP(B5,CustomerService1!A5:I20,9,FALSE),"")

Thanks in advance.

 

[pete4monc]

Are you trying to return values from column H, I, or J?
Because from that image it looks as though J is blank

Return from column I

 

[Fluff]

In that case use
=VLOOKUP(B5,CustomerService1!B5:I20,8,FALSE)

 

[pete4monc]

There must've been something with the formatting in the original column. I have created a completely new column and put in the formula and the correct dates come up where applicable but now the 00/01/1900?

 

[Fluff]

That date means that it found the value in col B, but col I was blank. What do you want to do in that situation?

 

[pete4monc]

That date means that it found the value in col B, but col I was blank. What do you want to do in that situation?

Just return a "blank cell" or "nothing".

 

[Fluff]

Ok, how about
=IFERROR(1/(1/VLOOKUP(B5,CustomerService1!B5:I20,8,FALSE)),"")

 

[pete4monc]

Ok, how about
=IFERROR(1/(1/VLOOKUP(B5,CustomerService1!B5:I20,8,FALSE)),"")

I tried
=IFERROR(VLOOKUP(B12,CustomerService1!B12:J27,8,FALSE),"")
It didn't work

BUT yours did, it Works a treat now !!!

Thanks for your quick response and help guys, I really appreciate it. @Fluff and @denzo36

 

[Fluff]

Glad we could help & thanks for the feedback