Lookup Relevant Value from table

Solved/Closed
Gokuneo Posts 8 Registration date Monday October 19, 2015 Status Member Last seen October 31, 2015 - Oct 23, 2015 at 11:09 AM
Gokuneo Posts 8 Registration date Monday October 19, 2015 Status Member Last seen October 31, 2015 - Oct 31, 2015 at 01:22 AM
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
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 27, 2015 at 12:48 PM
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
Gokuneo Posts 8 Registration date Monday October 19, 2015 Status Member Last seen October 31, 2015
Oct 27, 2015 at 02:17 PM
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,.....
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 29, 2015 at 11:53 AM
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
Gokuneo Posts 8 Registration date Monday October 19, 2015 Status Member Last seen October 31, 2015
Oct 31, 2015 at 01:22 AM
Thanks a Ton!!! Its working,....