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

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
1
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,.....
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0
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,....
0