VLOOKUP with Column Letter

[Nanogirl21]

Is there any w/ay to write a VLOOKUP that will return the value in a specific column that is identified by a letter instead of the number of cells from a refrence point?

I hope my quiestion makes sense. I had a diffifuclt time trying to come up with the correct words

EXAMPLE:

CURRENT VLOOKUP:

=VLOOKUP(B16,Apples!B:Z,[B]17[/B],FALSE)

WANTED RESULTS SOMETHING LIKE:

=VLOOKUP(B16,Apples!B:Z,Column R,FALSE)

 

[Marcelo Branco]

@Nanogirl21

Have you seen the formula in post 5?

M.

 

[Aladin Akyurek]

Yes, should be 18 not 17. That was a mistake.

I do have headers. The headers in all columns of the first row. R1 is called Comments.

That's great...

=VLOOKUP(B16,Apples!B:Z,MATCH("Comments",INDEX(

Apples!B:Z,1,0),0),0)

The last two zero's are another way of saying FALSE.
​

 

[Tetra201]

How does this version know what column to look in? Is it always the last column refrencd in the range? If I want to use the same formula but return the value of column G would I use COLUMNS(B:G)?

Yes, this is correct -- you would use COLUMNS(B:G) to return value from column G. Important thing is to use the same start column as your table array:

=VLOOKUP(B16,Apples!B:Z,COLUMNS(B:G),FALSE)

 

[Tetra201]

Yes, should be 18 not 17. That was a mistake...

No, there was no mistake -- 17 is the correct number. Column R's numeric position with regard to column B is 17:

=VLOOKUP(B16,Apples!B:Z,17,FALSE)