Lookup Relevant Value from table

[Solved/Closed]
Report
Posts
8
Registration date
Monday October 19, 2015
Status
Member
Last seen
October 31, 2015
-
Posts
8
Registration date
Monday October 19, 2015
Status
Member
Last seen
October 31, 2015
-
Hello Team,

I have a doubt, Consider the table :
Event A B C
1 3020 3420 1324
2 3005 3405 5462
3 2990 3390 7851
4 2975 3375 9652
5 2960 3360 7526
6 2945 3345 1576
7 2930 3330 7563
8 2915 3315 7589
9 2900 3300 1286
10 2885 3285 7588

Enter Info
a) Enter city..... Either A/B/C
b) Enter event number .... 10

Query
a) Any formula that would bring up relevant value after we enter the price of event according to the city (Eg.., when entering A and event 5, it should give 2960 and , if we enter B and event 9- it should give 3300)

Thanks in advance

2 replies

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Gokuneo,

Let's say you enter event in A15 and city in B15, then try this formula:
=VLOOKUP(A15,A2:D11,IF(B15="A",2,IF(B15=" B",3,IF(B15="C",4,1))))

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
8
Registration date
Monday October 19, 2015
Status
Member
Last seen
October 31, 2015

Thanks for the effort,..
Its Working for City A, and City C. But the events value is not getting selected for city B- on that it seems to be returning the "event value" back,.....
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Sorry Gokuneo, made a mistake.

There seems to be a space before the B that shouldn't be there.

Formula should be:
=VLOOKUP(A15,A2:D11,IF(B15="A",2,IF(B15="B",3,IF(B15="C",4,1))))

Best regards,
Trowa
Posts
8
Registration date
Monday October 19, 2015
Status
Member
Last seen
October 31, 2015

Thanks a Ton!!! Its working,....