| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup again
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup again
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup again
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup again
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 |
|
#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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup again
in"H1" =vlookup(a1,tbl,3,false)
But it just return first value from my table, i need obtain secound record in H2 and so on "Nick Hodge" wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup again
H1:
=IF(ISERROR(SMALL(IF(($A$1:$A$6=10)+($B$1:$B$6=10) 0,ROW($A$1:$A$6)),ROW(A1))),"",10) Enter with control + Shift + Enter rather than just enter since this is an array formula I1: =IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",INDEX($C$1:$C$7,SM ALL(IF(($A$1:$A$6=10)+($B$1:$B$7=10)0,ROW($A$1:$A $7)),ROW(A1)),1)) Entered with Ctrl+Shift+Enter rather than just enter since this is an array formula Select H1:I1 and drag fill down the column. -- Regards, Tom Ogilvy "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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup again
My test data only went to row 6, so I didn't get all the formula ranges
changes. Let me try again: H1: =IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",10) Enter with control + Shift + Enter rather than just enter since this is an array formula I1: =IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",INDEX($C$1:$C$7,SM ALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10)0,ROW($A$1:$A $7)),ROW(A1)),1)) Entered with Ctrl+Shift+Enter rather than just enter since this is an array formula Select H1:I1 and drag fill down the column. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... H1: =IF(ISERROR(SMALL(IF(($A$1:$A$6=10)+($B$1:$B$6=10) 0,ROW($A$1:$A$6)),ROW(A1))),"",10) Enter with control + Shift + Enter rather than just enter since this is an array formula I1: =IF(ISERROR(SMALL(IF(($A$1:$A$7=10)+($B$1:$B$7=10) 0,ROW($A$1:$A$7)),ROW(A1))),"",INDEX($C$1:$C$7,SM ALL(IF(($A$1:$A$6=10)+($B$1:$B$7=10)0,ROW($A$1:$A $7)),ROW(A1)),1)) Entered with Ctrl+Shift+Enter rather than just enter since this is an array formula Select H1:I1 and drag fill down the column. -- Regards, Tom Ogilvy "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 |
| Reply |
| 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 | |||
Hybrid Mode
