searching through cells

[ashah235]

I have data arranged in two colums.
Column A Column B
DataBig DataBig'sValue
DataBig2 DataBig2'sValue
DataBig1300 DataBig1300'sValue

I want to search through the titles in Column A (DataBig) and output the corresponding value(DataBig'sValue) in Column B. The VLOOKUP function is too dumb because I have to have the exact value of the name (Databig) in Column A...I want to input "searchname" and search through the values in Column A and output Column A values and their corresponding Column B values that partially match the "search name".
PLEASE HELP.

 

[Aaron]

On 2002-10-25 10:31, ashah235 wrote:
I have data arranged in two colums.
Column A Column B
DataBig DataBig'sValue
DataBig2 DataBig2'sValue
DataBig1300 DataBig1300'sValue

I want to search through the titles in Column A (DataBig) and output the corresponding value(DataBig'sValue) in Column B. The VLOOKUP function is too dumb because I have to have the exact value of the name (Databig) in Column A...I want to input "searchname" and search through the values in Column A and output Column A values and their corresponding Column B values that partially match the "search name".
PLEASE HELP.

If you are using the FALSE option on your VLOOKUP, try taking it out and see what happens =VLOOKUP(A1,A2:B20,2)

 

[ashah235]

If you are using the FALSE option on your VLOOKUP, try taking it out and see what happens =VLOOKUP(A1,A2:B20,2)

Aaron-
that doesn't work because it gives values based on a partial match...ie the first characters of a cell matching.

anand

 

[ashah235]

If you are using the FALSE option on your VLOOKUP, try taking it out and see what happens =VLOOKUP(A1,A2:B20,2)

Aaron-
that doesn't work because it gives values based on a partial match...ie the first character of a cell matching instead of a matching entire string. it also will not output multiple values and does not tell me the value in column a it matched to.

anand
Column C Column D
C1 B15="VLOOKUP(C1,A1:B20,2)'s Output" when the actual value is B18...i want the output to be
Column C ColumnD
C1 A18=MyLookup Function(C1,A1:B20,1)
Column E
B18=MyLookup Function(C1,A1:B20,2)