HLOOKUP and VLOOKUP work with text and numbers. Search for a value in one set of cells and return a value from rows to the right or below.
"GregChi" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] OOo 2.0 / win98se/ calc 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? (my text is/could be 'Expressions Flowers'). -- Greg Agent 1.93/32.576 Opera8.5 OOo2.0 Eudora(NG7)6.2.5.6 news.readfreenews.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: geardocATgeardoc36DOThostingisfreeDOTcom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
