GregChi <[EMAIL PROTECTED]> writes: > > In cell c4, I have text entered. > In cells c100 thru c120, I have text, one of which is the same as in > c4. > In cells d100 thru d120, I have numbers. > In cell d4 I want to write a formula that matches c4 to one in the > c100 thru c120 list & prints the corresponding number in d100 thru > d120. > > Lookups/match/choose all use numbers as matches??? > Do any of these work with text? > If so how do I write this?
Lookups and match will both look for text, as, according to Help, does Choose. The formula =MATCH(C4;C100:C120;1) in d4 will give the vertical position in the list. If you're after a cell address, insert the column letter and add a number (which I think is 99 in your case) to get the correct row in the spreadsheet, along these lines: ="C" & MATCH(B5;A2:A11;1)+99. In the other cells in the D column: =$D$4 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
