How to return text value

[perrydaniel]

Hi

I have 2 spreadsheets(SS1 and SS2), one which holds the main information, and another that holds some info from SS1 and some new stuff.

What i need to do is the following
SS1 has Ac No (Number),Amount(Number)and Ac Name (Text)
SS2 has Ac No (Number),Amount(Number)and Ac Name (Text)etc.

SS1 is manually updated, however i need to get SS2 to update automatically based on the account number. I have no problem returning anything with a number, but cannot get the Ac Name (Text) to return the value in SS2

Hope this makes sense, would appreciate your help!

Thanks

Perry

 

[xlbo]

How are you trying?

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[perrydaniel]

For all the fields that contain a number i am using the SUMIF function to return the numeric values in SS2, is there an equivalent function to return the text value?

Hope this is clearer

Perry

 

[xlbo]

If there is a 1:1 relationship, then you shouldn't need to use SUMIF - that is for aggregating multiple values. Have a look at the VLOOKUP() function which will return ANY data against a matching criteria.

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question