Thanks, I got caught (again) with the RegExp flag (I had some parantheses in the text & reg expr goes berserk....)
=IF(ISNA(VLOOKUP(C4;$C$100:$F$120;3;0));"";VLOOKUP(C4;$C$100:$F$120;3;0)) finds my key-code... :-) On Sat, 21 Jan 2006 07:36:04 -0800, Dennis Marks wrote: >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]
