rochytall2000
New Member
 Joined
 Sep 15, 2006
 Messages
 24
 Office Version

 365
 2019
HI all, it's been a while since I've posted.
I'm trying to do a "VLOOKUP" of sorts across two tables in different sheets
I want to compare value in B4 on Sheet 1 (data listed vertically) against an array on Sheet 2 ( (A4 is start of array data listed horizontally, each row is a unique ID with various columns of data)
Sheet 1 (B4:B7121)
Sheet 2 (A4:F893)
What I am struggling with is creating a formula (or combining formula) so that I can drag it down in sheet one, and as I go, B4 changes to B5 and the "VLOOKUP" column changes to Column 2.
I've tried using COLUMN() but I don't think I'm using it correctly within my VLOOKUP
I've also looked at combing INDEX and MATCH but again I think I'm way off
Any and all help greatly appreciated, it is probably something simple I am missing
Thanks Duncan
I'm trying to do a "VLOOKUP" of sorts across two tables in different sheets
I want to compare value in B4 on Sheet 1 (data listed vertically) against an array on Sheet 2 ( (A4 is start of array data listed horizontally, each row is a unique ID with various columns of data)
Sheet 1 (B4:B7121)
Sheet 2 (A4:F893)
What I am struggling with is creating a formula (or combining formula) so that I can drag it down in sheet one, and as I go, B4 changes to B5 and the "VLOOKUP" column changes to Column 2.
I've tried using COLUMN() but I don't think I'm using it correctly within my VLOOKUP
I've also looked at combing INDEX and MATCH but again I think I'm way off
Any and all help greatly appreciated, it is probably something simple I am missing
Thanks Duncan