| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup again
Bijan
Post your current formula -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "bijan" wrote in message ... Yes, you are right,but how can i do it , should i write 4 formula from h1 to h4? "Nick Hodge" wrote: or even wrap ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Nick Hodge" wrote in message ... Bijan I Think you will need to warp it in an IF(ISNA... like =IF(ISNA(Your_Original_Vlookup),"",Your_Original_V lookup) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "bijan" wrote in message ... Hi experts Please solve this plane sample with formula A B C .............................. H I 1 . . . ..............................10 1 2 10 . 1 ............................. 10 2 3 . . . ..............................10 3 4 . 10 2 .............................N/A N/A 5 . . . 6 . 10 3 7 . . . insted of N/A in last vlookup replace blank Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
