You guys are masters.....
Both work, and all three provide the same answers.
These will definitely be placed in my Excel toolbox.
Thank you.


"Pete_UK" wrote:

Try it this way in F2 of sht2:

=IF(ISNA(MATCH(E2,'sht1'!A:A,0)),"",INDEX('sht1'!B :B,MATCH(E2,'sht1'!
A:A,0)))

then copy it down. You could replace the INDEX part with your VLOOKUP
if you wish, so it would become:

=IF(ISNA(MATCH(E2,'sht1'!A:A,0)),"",VLOOKUP(E2,'sh t1'!A:B,2,0))

Hope this helps.

Pete

On Feb 2, 3:42 pm, SteveDB1
wrote:
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.