Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
JP wrote...
Hate to do this, but....wrap your formula in an IF function that uses ISNA. If ISNA evaluates to TRUE, it will display nothing. =IF(ISNA(VLOOKUP($A$32,Data!$A$4:$M$18, MATCH($B$3,Data!$B$4:$M$4,0)+1,0)),"", VLOOKUP($A$32,Data!$A$4:$M$18,MATCH($B$3,Data!$B$ 4:$M$4,0)+1,0)) .... There are 3 ways the VLOOKUP call could return #N/A: A32 doesn't occur in A4:A18 (or is #N/A itself), B3 doesn't occur in B4:M4 (or is #N/A itself), or the cell corresponding to A32 and B3 happens to evaluate to #N/A. The last should propagate in most situations. It's possible to handle the first two with =IF(COUNT(MATCH($A$32,Data!$A$4:$A$18,0), MATCH($B$3,Data!$B$4:$M$4,0))=2, VLOOKUP($A$32,Data!$A$4:$M$18,MATCH($B$3,Data!$B$4 :$M$4,0)+1,0),"") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can the Match function handle more than 7 variables? | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
MAC Retrieval | Excel Discussion (Misc queries) | |||
Appl need that VLOOKUP will not handle | Excel Worksheet Functions |