If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
"VLOOKUP??"
Don,
N doesn't have tgo come before Y, just add a final argument of FALSE =VLOOKUP(A1,Sheet2!A12,3,False) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Hi Dave, Not sure in your case, but when I do that, I can blame it on old age.....lol Anyway, as I stated below, I found the answer thanks to the link you put up. N has to come before Y in the List. It's working fine now...I inserted an If (A1="","",VLOOKUP.......... Works great now... Again, thanks for the help. Don -----Original Message----- Sorry I got my rows and columns mixed up, I think I noticed I was slipping yesterday when I indicated A2 when I meant B1. To suppress N/A errors: with default False you are looking for an exact match. =IF(ISNA(VLOOKUP(...,...,...,False)),"Item not found",VLOOKUP(...,...,...,False)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm wrote in message ... hmmmmmmm.....I must be misinterpreting something here....as I look at what I have, I have 4 columns....A thru D, and two Rows 1 & 2. Why does the Y give me . |
#12
|
|||
|
|||
"VLOOKUP??"
Thanks again Bob,
Tried that in all combinations, works fine no matter what the order. A lesson I won't soon forget.... Don -----Original Message----- Don, N doesn't have tgo come before Y, just add a final argument of FALSE =VLOOKUP(A1,Sheet2!A12,3,False) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Hi Dave, Not sure in your case, but when I do that, I can blame it on old age.....lol Anyway, as I stated below, I found the answer thanks to the link you put up. N has to come before Y in the List. It's working fine now...I inserted an If (A1="","",VLOOKUP.......... Works great now... Again, thanks for the help. Don -----Original Message----- Sorry I got my rows and columns mixed up, I think I noticed I was slipping yesterday when I indicated A2 when I meant B1. To suppress N/A errors: with default False you are looking for an exact match. =IF(ISNA(VLOOKUP(...,...,...,False)),"Item not found",VLOOKUP(...,...,...,False)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm wrote in message ... hmmmmmmm.....I must be misinterpreting something here....as I look at what I have, I have 4 columns....A thru D, and two Rows 1 & 2. Why does the Y give me . . |
#13
|
|||
|
|||
"VLOOKUP??"
It should be the default :-)
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Don" wrote in message ... Thanks again Bob, Tried that in all combinations, works fine no matter what the order. A lesson I won't soon forget.... Don -----Original Message----- Don, N doesn't have tgo come before Y, just add a final argument of FALSE =VLOOKUP(A1,Sheet2!A12,3,False) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Hi Dave, Not sure in your case, but when I do that, I can blame it on old age.....lol Anyway, as I stated below, I found the answer thanks to the link you put up. N has to come before Y in the List. It's working fine now...I inserted an If (A1="","",VLOOKUP.......... Works great now... Again, thanks for the help. Don -----Original Message----- Sorry I got my rows and columns mixed up, I think I noticed I was slipping yesterday when I indicated A2 when I meant B1. To suppress N/A errors: with default False you are looking for an exact match. =IF(ISNA(VLOOKUP(...,...,...,False)),"Item not found",VLOOKUP(...,...,...,False)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm wrote in message ... hmmmmmmm.....I must be misinterpreting something here....as I look at what I have, I have 4 columns....A thru D, and two Rows 1 & 2. Why does the Y give me . . |
|
Thread Tools | |
Display Modes | |
|
|