Two worksheets, one array

[Guest]

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

 

[Ken Johnson]

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)),"",VLOOKUP(A2,Sheet1!A2:B25,2,FALSE)))

Ken Johnson

 

[Guest]

Something like

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

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

HTH,

TK