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]

No errors, just #N/A in the return.

#N/A is an error.
Try

=VLOOKUP($B$2,Hstry!$A$3:$F$70,6,FALSE)

 

[RoryA]

So the lookup value is not being found. Often this is because it's a number in one location and stored as text in the other.

 

[erutherford]

Thanks Fluff for the reply. I see what you did but same results. My index is a dropdown menu pulling the data from Sheet1 if that has any effect.

 

[erutherford]

So the lookup value is not being found. Often this is because it's a number in one location and stored as text in the other.

I saw that in my problem searching and everything is in "general" format

 

[Fluff]

What is in B2 & col A of the Hstry sheet?

 

[erutherford]

What is in B2 & col A of the Hstry sheet?

 

[Fluff]

Do you have 2022 in B2?

 

[erutherford]

Do you have 2022 in B2?

No. B2/Sheet 2 is the index("Cassler") that I am trying to lookup the associated data

 

[erutherford]

Fluff,
I think I see the issues and let me clean up column, then I'll continue the tread successful or not. Standby