| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with IF formula
=VLOOKUP(LOWER(A1),{"yes",10; "no",5; "n/a",0},2,FALSE)
On Jan 9, 10:40 am, Deepak wrote: Value in Cell should give result in B1 A1 - Yes, Then it should show B1 - 10 A1 - No, Then it should show B1 - 5 A1 - N/a, Then it should show B1 - 0 Thanks in advance Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
