Have A = B formula needed

[jbilt001]

Hello, I need a formula so that when you select a type of service in one column, it automatically generates the cost for that service in the next column. I'm sure this is pretty simple, but I can't figure it out for the life of me. Any help is appreciated

[MrShorty]

It sounds like it should be one of Excel's lookup functions: https://support.office.com/en-us/art...__toc309306714

For the uninitiated, the VLOOKUP() function is usually a good place to start.

[etaf]

you can use a vlookup or index match

Assuming you had the service in column A of sheet2
and the cost in column B of sheet2

and the service you want to lookup n column A on sheet 1 and want the answer in column B sheet1
=VLOOKUP(A2,Sheet2!$A$1:$B$11,2,FALSE)

see attached

[Tony Valko]

Check this out:

http://www.contextures.com/xlFunctions02.html

Includes videos!