VLOOKUP not functioning as expected

[Lexxington87]

Hi all,

I've attached an example (sorry it's not a few lines, the data is spread where doing that will take me a very long time).


In Column B (Other Box Identifier) there is a VLOOKUP looking for the value in column A (Vendor Box Identifier), pulling a value in Column H (Other Box Identifier), paired with a table (Columns H-I), with a return value of Column H as that's the value i'm looking for.

The formula seems to be partially working, however it's not returning all the results. I know for a fact the value in A8, has a match in column I, with an associated value in Column H, however the VLOOKUP does not return this. I can't figure out why, as it's matching some items but not all. Any view on what i'm doing wrong?

Thank you!

[AliGW]

Welcome to the forum.

The array is incorrect. Try this:

=VLOOKUP(A2,I:I,1,FALSE)

I do wonder, though, if this is what you are trying to do:

=INDEX(H:H,MATCH(A2,I:I,0))

VLOOKUP works natively from left to right, not from right to left.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Lexxington87]

Hi there -

In-fact, you solved my problem but with your suggestion VLOOKUP only works left to right. I swapped I and H around and it worked, sigh

I was trying to pull values from column H, not I, so the forumula was correct:

=VLOOKUP(A2,H:I,1,FALSE)

but I had to swap columns H and I around in the sheet, and it worked. Thanks!

[Lexxington87]

Sorry formula was:

=VLOOKUP(A2,H:I,2,FALSE)

[AliGW]

Glad to help.

In future, always mock up at least 15 rows of manually calculated results data so that we know what you are aiming for.