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
Gokuneo Posts 8 Registration date Monday October 19, 2015 Status Member Last seen October 31, 2015 - Oct 31, 2015 at 01:22 AM
Related:
- Lookup Relevant Value from table
- School time table software free download full version - Download - Organisation and teamwork
- How to delete part of a table in word - Guide
- Ascii table c++ - Guide
- Html table fit to screen - Guide
- Area code lookup - Guide
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
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 29, 2015 at 11:53 AM
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
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
Oct 31, 2015 at 01:22 AM
Thanks a Ton!!! Its working,....
Oct 27, 2015 at 02:17 PM
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,.....