Lookup (2003)

Topic

New Reply

I want to take a value (‘TC Scenario’!A5), go to another data sheet (‘Dose chart’!) and find that value between cells B8:E8.

Once I have located the associated column, I want to scan down the column and verify that the value in ‘TC Scenario’!A8 exists. “true”,”error”

Reply | Quote

Replies

If I understand correctly:

=IF(ISNUMBER(MATCH(‘TC Scenario’!A8,INDEX(‘Dose chart’!B9:F100,0,MATCH(‘TC Scenario’!A5,’Dose chart’!B8:F8,0)),0)),”true”,”error”)

I presumed you wanted to look in rows 9:100 of Cols B:F for the value in A8. If not adjust the range as desired…

Steve

Reply | Quote

THANK YOU! I tried for 2 hours (obviously unsuccessfully).
It was PERFECT!

Reply | Quote