lookup

V

vbastarter

I'm looking how to achieve this thru any of the excel functions like lookup,
search etc
so that I can add this function to a macro. I have to find column A values
occuring anywhere inside Column b, c, d

Ex A B C
D
Rio 2 Carona Rep Ford Teac
Carona Belowa Mazda Mitsh
Sung Renault Pana Tos

So I like to extract Row 1 since B1 Contains "Carona" from A2.

Thanks in Advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup, search? 4
Query regarding any lookup function 3
Lookup 14
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Lookup a name if cell value first letter is in a range 1
lookup needed to give value where the lookup value is a string within a cell. 2
What type of "lookup" 3

Top