worksheet function...
Hi Steve
If I have understood you correctly, then
=IF(E2="","",INDEX(Sheet1!B:B,MATCH(E2,Sheet1!A:A, 0)))
--
Regards
Roger Govier
"SteveDB1" wrote in message
...
morning all.
I want to look through a range of cells and match two cells, then in a
third
cell place a specific value.
I.e., something akin to the following.
Sht1-column A sht1-ColumnB sht2-Column E sht2-ColumnF
12345 A 34258
?
34258 B blank
?
56789 C 12345
?
For sht2-ColumnF I want to do a worksheet function that will match up the
matching 5 digit numbers sht1-columnA and sht2-Column E, and then insert
the
correct letter to column F.
Last week I'd tried something akin to:
=if(A2=match('sht2'!F2,f1:f190,0),vlookup(......), "")
and of course it failed. This morning I realized that it was because my
match only returns the location if the response is true, and and N/A error
if
the value cannot be found.
I need a Letter input in the F column IF the 5 digit number series
matches,
and blank if there's no 5 digit series in Column E.
If this is not clear, please advise, and I'll try explaining it
differently.
|