#1
|
|||
|
|||
Excel 2019: How to apply if statement for multiple values?
Excel 2019: How to apply if statement for multiple values? In the screenshot below, the first table has 12 rows at which each letter has a specific value. What I wanted in the second table is to get the corresponding value of each letter printed. For example, if the letter A is printed in the second table then its corresponding value should be 50 while if the letter be is printed then the value is 40 and so forth. The data is attached
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
||||
|
||||
In cell H2:
=VLOOKUP(G3,$C$3:$D$14,2,FALSE) and copy down. This is very basic stuff - is this course work? |
#3
|
|||
|
|||
Thank you p45cal. It works fine.
Don’t worry. It’s not a course work
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What's new in Word 2019, Excel 2019 and Outlook 2019 and Why upgrade to Office 2019 is recommended? | einfomail | Office | 1 | 07-26-2019 09:44 AM |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
VBA Word - Find & Apply Styles to Specific Words - Using Case Statement | jc491 | Word VBA | 17 | 12-26-2015 12:25 PM |
Excel - search Multiple Values (HELP!) | duskdjl | Excel | 4 | 03-28-2013 01:11 AM |