Hello,
I have a Problem in Excel.
I have a row with Words and Numbers. Now i want to search a number and than excel should return the cell, left to the found number.
I Hope you guys can follow me.
Thanks
AmiGoCS from Germany
Hello,
I have a Problem in Excel.
I have a row with Words and Numbers. Now i want to search a number and than excel should return the cell, left to the found number.
I Hope you guys can follow me.
Thanks
AmiGoCS from Germany
A1:one B1:1
A2:Two B2:2
A3:Three B3:3
assuming the value to be searched for is entered in C6: as 2
type in C7: =INDEX(A:A,MATCH(C6,B:B,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks