Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can you please tell me how to lookup cells and transfer them to a list,
eg Data in sheet 1 A B 2 100 5 50 4 75 2 250 5 95 2 60 I want to lookup the value "2" in the Column A of the data in sheet 1 and and transfer to another sheet to appear as below(keeping in mind i dont want blanks cells where the other A values were); Sheet 2 A B 2 100 2 250 2 60 Thank you in advance Dan |