| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two worksheets, one array
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
| Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| printing an array of worksheets | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
