Question description:
This user has given permission to use the problem statement for this
blog.
Hi. Been on this problem for days now. Here is the formula I have managed to come up, it works ok and does what I need but I need the D3 and E3 to be referenced in the same way as the FEE_Table as when I . For instance when I select a value from the data validation list in Y2, if the value in AA2 is blank it returns value from Postage!D3, but if not it returns value from Postage!E3. These D3 & E3 values are in the same FEE_Table. So am hoping there is some way I can include in the IF function another Vlookup which chooses the value I want. Any help would be much appreciated. Thanks
=VLOOKUP(Y2,FEE_Table,4,0)+IF(AA2="",Postage!D3,Postage!E3)
Solved by M. A. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
25/03/2018 - 04:00
Do you want to create formula which will take value from your input table? Right in case user selects option A, then column 1 from your list should answer & same for option B. Am I correct?
User
25/03/2018 - 04:01
Yes I think that's correct. I'm trying to upload file
Excelchat Expert
25/03/2018 - 04:01
Ok
User
25/03/2018 - 04:01
its not doing it. I will use sheet on right 2 seconds
Excelchat Expert
25/03/2018 - 04:02
sure
User
25/03/2018 - 04:02
this is a data validation list
User
25/03/2018 - 04:03
PAN EU is either blank or contains yes
Excelchat Expert
25/03/2018 - 04:03
ok
User
25/03/2018 - 04:05
Ok, so when I select A1 I need C2 to bring a value from the table in postage sheet, either D or E depending on whether B2 contains the yes or blank
Excelchat Expert
25/03/2018 - 04:06
ok
User
25/03/2018 - 04:06
ignore the "no" in B2, I will delete that
Excelchat Expert
25/03/2018 - 04:06
I will make it blank
User
25/03/2018 - 04:06
is just going to be Yes or blank
Excelchat Expert
25/03/2018 - 04:07
ok
Excelchat Expert
25/03/2018 - 04:14
What will be the value of fulfilment fee?
Excelchat Expert
25/03/2018 - 04:14
De PAN FEE?? Or Sum of all?
User
25/03/2018 - 04:15
it will be on the postage tab, either D or E. the value is depending on which value in A is selected
User
25/03/2018 - 04:16
it currently shows MF Large letter, but that is further down the list. This might make more sense
Excelchat Expert
25/03/2018 - 04:17
I am not able to see MF Large letter in postage sheet. can you state row number?
User
25/03/2018 - 04:17
so now I've selected FBA Small Envelope it should be showing the value £1.43 from the table, as PAN is selected
Excelchat Expert
25/03/2018 - 04:17
ok
User
25/03/2018 - 04:17
I've just changed it now. I should of said
User
25/03/2018 - 04:18
and when PAN EU YES is blank, it needs to read the value in the D on the postage sheet
Excelchat Expert
25/03/2018 - 04:19
ok And if it is yes it should read E column
User
25/03/2018 - 04:19
yes
Excelchat Expert
25/03/2018 - 04:19
ok.. give me few minutes
User
25/03/2018 - 04:19
cool :) you'll be my hero if you do this!
Excelchat Expert
25/03/2018 - 04:20
I will help you with all my best
User
25/03/2018 - 04:20
thanks, is much appreciated
Excelchat Expert
25/03/2018 - 04:24
Can you check please?? If things are like your expectations
User
25/03/2018 - 04:26
The PAN just needs to have 1 selection, either YES or blank
Excelchat Expert
25/03/2018 - 04:26
ok
Excelchat Expert
25/03/2018 - 04:35
Just few more minutes.. Thanks for extending
User
25/03/2018 - 04:35
no problem
Excelchat Expert
25/03/2018 - 04:46
I cannot create blank option in spread sheet but in offline excel for sure. Thats why I used ' sign to mark. Will that work or else I can copy your file & upload it as attachment?
User
25/03/2018 - 04:46
That's ok I can work with that. I'll have a look
User
25/03/2018 - 04:47
How would when I select the ` it returns the value in D on postage sheet
Excelchat Expert
25/03/2018 - 04:47
Please go to data validation tab>> settings>>include blank option from including drop down option..
Excelchat Expert
25/03/2018 - 04:47
Just a min
User
25/03/2018 - 04:49
it doesn't give the option for a blank cell
Excelchat Expert
25/03/2018 - 04:50
I will check
Excelchat Expert
25/03/2018 - 04:53
Can you open your excel
User
25/03/2018 - 04:53
sure
Excelchat Expert
25/03/2018 - 04:53
Go to data tab
Excelchat Expert
25/03/2018 - 04:53
under that data validation
User
25/03/2018 - 04:53
in my excel, blank option is selected
Excelchat Expert
25/03/2018 - 04:54
Under data validation, select list
Excelchat Expert
25/03/2018 - 04:55
under allow tab
Excelchat Expert
25/03/2018 - 04:55
there You will have to uncheck the option ignore blank
User
25/03/2018 - 04:56
I've done it in my excel
Excelchat Expert
25/03/2018 - 04:56
now Anywhere on excel make a list like the one I am doing
User
25/03/2018 - 04:56
ok
Excelchat Expert
25/03/2018 - 04:56
Highlighted one. And select these 2 cells as source in data validation tab.
Excelchat Expert
25/03/2018 - 04:57
Your drop down will have now 2 options.
Excelchat Expert
25/03/2018 - 04:57
blank & Yes
Excelchat Expert
25/03/2018 - 04:57
Paste the formula & drag for cells you want
User
25/03/2018 - 04:58
Ok, I think has sorted it now, many thanks for help!!!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
