Danielle22103
New Member
- Joined
- Dec 15, 2005
- Messages
- 13
Hi there
I was given this formula to search a worksheet against a cell.
=ISNUMBER(MATCH(A1,'Sheet1!$A$2:$A$606,0))
How do i now change the formula so that the data to the right (or left) of the column that i am seaching, is entered in the cell rather than just true or false.
i was using =VLOOKUP(A1,Sheet1!$A$2:$A$606,2,0) -but its not working.
Cell Sheet 1 Sheet 1
A1 Column A ColumnB
73307 73307 31-Jul-02
Can someone help me?
I was given this formula to search a worksheet against a cell.
=ISNUMBER(MATCH(A1,'Sheet1!$A$2:$A$606,0))
How do i now change the formula so that the data to the right (or left) of the column that i am seaching, is entered in the cell rather than just true or false.
i was using =VLOOKUP(A1,Sheet1!$A$2:$A$606,2,0) -but its not working.
Cell Sheet 1 Sheet 1
A1 Column A ColumnB
73307 73307 31-Jul-02
Can someone help me?