Log In
Register
Home
Active Member
July 29, 2018
Offline
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
See Answer
VIP
Trusted Members
June 25, 2016
Offline
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
Answers Post
Active Member
July 29, 2018
Offline
Hi Sunny,
Thanks for the quick response. I will try the formula you shared and let you know how it works for me.
Active Member
July 29, 2018
Offline
Hi again Sunny,
I'm just learning how to use this forum. Hopefully the file will be attached this time.
Thanks,
Cindi
1 Guest(s)
