Hi! I Need help with a formula in Excel

Occasional Visitor

Can someone please help advise me if it is possible to link a word in one cell with a dollar value in another cell.  i have a fee sheet that i am wanting to merge in word and want to be able to enter a subject (column a) and have the fee(column B) for that subject to automatically pop up with it.  i have been given data from two spreadsheets and am hoping i can merge the two.

thank you in advance.

1 Reply
Highlighted

if you need to add two strings in different cells you can use "&" operator or concatenate function (tehy both work the same way) for example

 

=Sheet1!A1 & Sheet2!B2

 

will combine values in sheet a1 cell and sheet b2 cell as a string in the cell this formula is written.