Vlookup produces #value

[vba317]

I have a formula that is giving me a #value error. I am trying to match the value in Sheet1!B2 to Sheet2|ColumnB I have tried different combinations with no luck. The value I am looking for is in Sheet2!B94.

=VLOOKUP(TRIM(Sheet1!B2)|TRIM(Sheet2!A1:B94)|2|FALSE)

 

[Brian from Maui]

I have a formula that is giving me a #value error. I am trying to match the value in Sheet1!B2 to Sheet2|ColumnB I have tried different combinations with no luck. The value I am looking for is in Sheet2!B94.

=VLOOKUP(TRIM(Sheet1!B2)|TRIM(Sheet2!A1:B94)|2|FALSE)

The TRIM on A1:B94 produces the #VALUE error. Why don't you just clean up the lookup range and lookup value. Is that how you're entering the formula with ||

 

[vba317]

I am using | with the formula because commas cause an error. What do you mean by clean up the range?

 

[Brian from Maui]

I am using | with the formula because commas cause an error. What do you mean by clean up the range?

Normally when using TRIM, there's leading or trailing spaces. What's your purpose in using TRIM?

 

[vba317]

Thanks I took TRIM out and it works, Thanks!