# if and vlookup for excel- help neededWatch

#1
hi...
so i have 3 worksheet
1- costs- that has all the data in e.g. tables
2- quotation- where the user add the information and workout the total cost
3- breakdown- this is where the quotation (total) cost come from...
i have used if statement to workout the cost per day, discount but it only works for 90 days (user can hire the van from 3 to 90 days) but it won't work if the user wants to hire for 33 days
so i want to just ask for some guidance that how can i use "if and vlookup" statement to make it all work!
i tried this formula but it didn't work
=IF(C4 = "Low" VLOOKUP(Quotation!F13, Costs!\$G\$5: \$H\$15,2,FALSE))
0
3 years ago
#2
(Original post by fatima1998)
hi...
so i have 3 worksheet
1- costs- that has all the data in e.g. tables
2- quotation- where the user add the information and workout the total cost
3- breakdown- this is where the quotation (total) cost come from...
i have used if statement to workout the cost per day, discount but it only works for 90 days (user can hire the van from 3 to 90 days) but it won't work if the user wants to hire for 33 days
so i want to just ask for some guidance that how can i use "if and vlookup" statement to make it all work!
i tried this formula but it didn't work
=IF(C4 = "Low" VLOOKUP(Quotation!F13, Costs!\$G\$5: \$H\$15,2,FALSE))
To me it seems like it is difficult to help without seeing the spreadsheets, but I don't know, it could be possible to help without them.
0
#3
(Original post by SeanFM)
To me it seems like it is difficult to help without seeing the spreadsheets, but I don't know, it could be possible to help without them.
i know!!! it is not going to be easy to explain what i am trying to do... but i am totally dead and crying... literally this task made me so cry
i don't mind sending you spreadsheet and then u can give me feedback?
0
X

new posts
Back
to top
Latest
My Feed

### Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

### See more of what you like onThe Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

### University open days

• Regent's University London
Thu, 19 Sep '19
• Durham University
Fri, 20 Sep '19
• Loughborough University
Fri, 20 Sep '19

### Poll

Join the discussion

Rock (116)
24.27%
Pop (110)
23.01%
Jazz (22)
4.6%
Classical (25)
5.23%
Hip-Hop (87)
18.2%
Electronic (37)
7.74%
Indie (81)
16.95%