VLookup - Column issue?

[erutherford]

I have two sheets (1 & 2) I am working in sheet 2, trying to pull data from sheet 1.

=VLOOKUP($B$2,Hstry!$A$3:$I$70,COLUMN(Hstry!F3),FALSE)

B2 on sheet 2 is my index and I am trying to lookup the value in Sheet1 in Column 6.
No errors, just #N/A in the return.

Thanks as always in advance

 

[Fluff]

Not surprising you get an #N/A error, vlookup looks for the value in the first column of the lookup range, ie col A.
Also I cannot see any names like "Casler, Chris" in any column of the Hstry sheet.

 

[erutherford]

This is the format of "Hstry" sheet where I am pulling data from.

This is the sheet where I want the data to land.

B2 is a drop down pulling from "Hstry" Col "J". When a name is selected the associated data will fill in (event year, class, etc.)

 

[Fluff]

In that case you need to use index/match like

=INDEX(Hstry!$A$3:$I$70,MATCH($B$2,Hstry!$J$3:$J$70,0),6)

 

[erutherford]

Thanks Fluff! As usual you are spot on correct. Thank you for patience and solution. I can modify the rest.

 

[Fluff]

Glad we could help & thanks for the feedback.