| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a value in table
There two columns lets say A & B. Both contains text for e.g A : A1=apple,
A2=ball, A3=cat..... and B: B1= cat,dolphin,bear , B2=apple,orange,banana , B3=ball,box,bat..... now i want to search the value of a cell in A Column lies where in B column...i.e. A1 lies in B2, A2 in B3 and so on.... which formula can do the job? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find a value in a table | Excel Discussion (Misc queries) | |||
| Find a second value in a table with VLOOKUP | Excel Worksheet Functions | |||
| Find a value in the table cell | Excel Worksheet Functions | |||
| Find data in one table from another. | Excel Worksheet Functions | |||
| Excel - Find a value in a Table !!??!! | Excel Discussion (Misc queries) | |||
Threaded Mode
