Looking for some help with a formula:
Looking to find a value in sheet 1, dependent on a value in column A in sheet 2.
seems fairly simple but, the the value required is not on a direct linear view.
so
Column A, row 4 in sheet 2 = "fred"
Somewhere in column B on sheet 1 = "fred"
The response back I need is then in sheet 1, column Q, but 2 rows below. eg "fred" is in B26, response required is in q28
I'm ok with vlookups, xlookups etc, but its this offset that i cant get.
any help appreciated
Looking to find a value in sheet 1, dependent on a value in column A in sheet 2.
seems fairly simple but, the the value required is not on a direct linear view.
so
Column A, row 4 in sheet 2 = "fred"
Somewhere in column B on sheet 1 = "fred"
The response back I need is then in sheet 1, column Q, but 2 rows below. eg "fred" is in B26, response required is in q28
I'm ok with vlookups, xlookups etc, but its this offset that i cant get.
any help appreciated