I've attached my spreadsheet below. I'm not sure whether I should use an IF Statement or a VLOOKUP.
#1
IF Function
If service code equals DSI or DSG then units equal hours times 1 otherwise units equals hours times 4.
I just can't get it to work right.
#2
VLOOKUP
I need Column A (Service Code) (what ever is chosen from the data validation on the data sheet) to automatically put the appropriate rate in Column D (Rate) also from the data sheet
So, in #1, I think I should use an "IF function." But, I'm having trouble getting the IF Function to work right. I've listened to multiple videos and I'm still missing something.
For #2, Should I use VLOOKUP or some other function and if VLOOKUP please advise how to proceed.
Thanks,
Cindi
Hi Cindi
There is no attachment.
For Q1 you can try =IF(OR(A1="DSI",A1="DSG"),1,4)*B1
Where A1 is your service code and B1 is your hours.
Can't answer Q2 until I see your file.
Sunny
Hi Sunny,
Thanks for the quick response. I will try the formula you shared and let you know how it works for me.
Hi again Sunny,
I'm just learning how to use this forum. Hopefully the file will be attached this time.
Thanks,
Cindi
Hi Cindi
Thank you for your file.
Please refer attachment. I have modified your service code table to include the rates.
Hope this helps.
Sunny
Thank you Sunny. It worked perfect!