Sheet1 Column A2:A25 has a list of numbers. I want to display in Sheet2 cell
A2 the number 725595 if it appears in Sheet1 Column A2:A25.

I also want to display in Sheet2 cell B2 the value that is in Sheet 1 Column
B in the same row as 725595.

Can anyone help?

Thanks,
Bob

bob wrote:
Sheet1 Column A2:A25 has a list of numbers. I want to display in Sheet2 cell
A2 the number 725595 if it appears in Sheet1 Column A2:A25.

I also want to display in Sheet2 cell B2 the value that is in Sheet 1 Column
B in the same row as 725595.

Can anyone help?

Thanks,
Bob


Hi Bob,

Does this work?...

In Sheet2 A2...

=IF(ISERROR(VLOOKUP(275595,Sheet1!A2:A25,1,FALSE)) ,"",VLOOKUP(275595,Sheet1!A2:A25,1,FALSE))


In Sheet2 B2...

=IF(ISERROR(VLOOKUP(A2,Sheet1!A2:B25,1,FALSE)),"", IF(ISBLANK(VLOOKUP(A2,Sheet1!A2:B25,2,FALSE)),"",V LOOKUP(A2,Sheet1!A2:B25,2,FALSE)))

Ken Johnson

Something like

=IF(ISERROR(MATCH(725595,Sheet1!A2:A25,0)),"",7255 95) in cell A2 of Sheet2,
and

=IF(A2="","",INDEX(Sheet1!B2:B25,MATCH(725595,Shee t1!A2:A25,0))) in cell B2
of Sheet2 should work.

HTH,

TK

"bob" wrote:

Sheet1 Column A2:A25 has a list of numbers. I want to display in Sheet2 cell
A2 the number 725595 if it appears in Sheet1 Column A2:A25.

I also want to display in Sheet2 cell B2 the value that is in Sheet 1 Column
B in the same row as 725595.

Can anyone help?

Thanks,
Bob