Using Vlookup and Index/Match across differing sheets

[JanusP]

So I have one table with differing columns of ID and its information per row on 1 sheet and another sheet has ID that asks for associated data from different columns.
Eg
ID is A column and info for associated is in D,E or B column. Each row has unique information.
On another sheet is ID and question asking for associated info from different columns

how to use these functions to solve the question? I tried
=VLOOKUP (InvestorData!B6, A2:N2501, 11)
=INDEX(InvestorData!M2:M2501,MATCH(B30,A2:A2501,0))
except they call from own sheet.

 

[sparky2205]

If I'm looking at the sheets correctly:
=VLOOKUP(B6,InvestorData!$A$2:$N$2501,11,0)

 

[JanusP]

If I'm looking at the sheets correctly:
=VLOOKUP(B6,InvestorData!$A$2:$N$2501,11,0)

I tried that and is wrong, with the red dotted lines

 

[sparky2205]

Your red dotted lines: =VLOOKUP(InvestorData!B6,A2:N2501,11)
My suggestion: =VLOOKUP(B6,InvestorData!A2:N2501,11,0)
These are not the same