Document "Mapping"?

[macrav]

I apologize if I have posted this in the wrong area but I am really just looking for a starting point.

What I would like to do is create a Word type document in Excel that I can easily save as a PDF. For example: an invoice. The reason I would like to do so in Excel is I would like the document to update as I enter it into Excel.

Example: I enter $50 in (Sheet 1, A1) and $50 appears on "amount due" area of the invoice on Sheet 2.


I swear I have seen Excel do this. I went to Google it and realized I didn't know the terminology to search for.

I don't expect anyone to fully teach me this as it's most likely over my head but if you could point me in the direction of an article or give me some search terms, that will get me started on the road to self-study. I'll be happy to do the work myself from there.

Thanks in advance!

[Kyle123]

I suspect that you're looking for Vlookup, but we'd need a bit more to go on