Forum

Notifications
Clear all

IF Function or VLOOKUP

6 Posts
2 Users
0 Reactions
65 Views
(@cynhall)
Posts: 4
Active Member
Topic starter
 

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

 
Posted : 29/07/2018 5:57 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 30/07/2018 3:04 am
(@cynhall)
Posts: 4
Active Member
Topic starter
 

Hi Sunny,

Thanks for the quick response. I will try the formula you shared and let you know how it works for me.

 
Posted : 31/07/2018 7:33 am
(@cynhall)
Posts: 4
Active Member
Topic starter
 

Hi again Sunny,

I'm just learning how to use this forum. Hopefully the file will be attached this time.

Thanks,

Cindi

 
Posted : 31/07/2018 7:35 am
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 31/07/2018 10:45 am
(@cynhall)
Posts: 4
Active Member
Topic starter
 

Thank you Sunny. It worked perfect! 

 
Posted : 01/08/2018 3:17 pm
Share: