V Look Up

[NGO05]

My question is pretty basic. How do I do a vloopup in any column. I only know how to do a vlookup when both spreadsheets have the first column the same and matches. I have seen people pull a vlookup without having the first column match. I usually cut and move the same columns in each spreadsheet to the front and then I do my vlookup.

Hopefully that makes sense!

 

[philwojo]

You can start your vlookup table array in any column, it does not have to match the value you are looking and its column.

Can you post your formula, it might help to better understand what you are asking, or you data.

But vlookup can only look to the right of the 1st column, the lookup value column, it can not find something in a column and go to the left of it.

 

[Aladin Akyurek]

Given A2:F10, you can have:

=VLOOKUP(X2,A2:F10,4,0)

which will match X2 against A2:A10 an if successful it will return a value from D2:D10.

=VLOOKUP(Y2,C2:F10,3,0)

will match Y2 against C2:C10 and if successful it will return a value from E2:E10.

=VLOOKUP(Z2,CHOOSE({1,2},D2:D10,A2:A10),2,0)

will match Z2 against D2:D10 and if successful it will return a value from A2:A10.

 

[NGO05]

Okay that makes sense!! Thank you!

 

[NGO05]

Gotcha, I think I understand what you mean now. Thank you!