Vlookup Error

[braidoo]

Hi so I have a reference issue with my Vlookup and I'm not sure why. All the data seems to be matching and the format of the cells match up.

If you look at sheet 1 column B should be looking up and copying information from Sheet 4 which should then have sheet 1 column E pull information from Sheet 2. Here's a link to a google docs version of the excel file.

https://docs.google.com/spreadsheets/d/15P8RbezE_9S3AKGg63v7uAV4NrymZ1KJBToE1L7L6NM/edit?usp=sharing

Any help would be greatly appreciated.

 

[Michael M]

Re: Vlookup Error Help

I don't have Excel to play with at the moment, but have you tried

=TRIM(VLOOKUP(D6,Sheet2!$B$2:$G$2765,5,True))

 

[arthurbr]

Re: Vlookup Error Help

First of all your lookup values in col D are numbers ( or text looking like numbers)
All values in the lookup range ( col B ) on sheet 2 are text strings
I don't think you can use TRIM on an entire range

 

[Aladin Akyurek]

Re: Vlookup Error Help

Your

=VLOOKUP(D6,'Sheet 4'!$B$11:$I$27,3,FALSE)

is trying to look up D6, hoursing "32077" as value in B11:B27 of Sheet4. The value does not exist in that range, hence #N/A.

You probably mean to look up in H11:H27 of Sheet4...

 

[braidoo]

Re: Vlookup Error Help

First of all your lookup values in col D are numbers ( or text looking like numbers)
All values in the lookup range ( col B ) on sheet 2 are text strings
I don't think you can use TRIM on an entire range

I have col D and col B as plain text.

 

[braidoo]

Re: Vlookup Error Help

You're a beautiful soul, that fixed it

 

[Aladin Akyurek]

Re: Vlookup Error Help

You are welcome.