Nested VLOOKUP (I think)

Hey guys,

I am trying to create a formula that will lookup a value from a cell in a table and then look at a cell that is relative to that position.

I.e. If it finds the value "1" in a cell, it will look in the first column of the table for the value "1" and once it finds it, get the reference of the cell three cells to the right of it (i.e. if 1 is in cell A1, return the value "A4" for use in another formula.)


I hope I have explained that well enough for you to understand and help!

Thank you for any help you can offer,

Rich

Hi guys,

Thanks for the speedy replies!

FDibbins - how would I go about using an index match combo - thats a new one on me!

Alansidman - thanks for the link, I have used plenty of VLOOKUPs before, but this seems out of their /my range!

Rich

Hey all,

With the links you have provided, I have put it together - thank you for your help!

Rich

Final Formula: =IF(G3>0,(IF(INDEX(DATA!$AD$231:$AG$262,G3,4)=0,"",(INDEX(DATA!$AD$231:$AG$262,G3,4)))),"")