If with Vlookup
=IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF((VLOOKUP( A2,males,6,0)),"XX","")).
I'm trying to use above to identify if A2 is on list names males by XX in results column. |
If with Vlookup
Fix your parentheses:
=IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF(VLOOKUP(A 2,males,6,0),"XX","")) Does the above work for you? If not give more detail about what errors/problems you're encountering. Dave -- Brevity is the soul of wit. "danwes" wrote: =IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF((VLOOKUP( A2,males,6,0)),"XX","")). I'm trying to use above to identify if A2 is on list names males by XX in results column. |
If with Vlookup
try
=IF(ISERROR(VLOOKUP(A2,males,6,0)),"","XX") the second vlookup would give a "" for any non positive-numeric answer from the 6th column "danwes" wrote: =IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF((VLOOKUP( A2,males,6,0)),"XX","")). I'm trying to use above to identify if A2 is on list names males by XX in results column. |
If with Vlookup
What's in column 6 of the "males" range?
Do you have the name in *both* the first and the sixth column of the range? If the name you're looking for is entered in A2, and it's in the first column of the "males" range, try this: =IF(ISNA(VLOOKUP(A2,males,1,0)),"","XX") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "danwes" wrote in message ... =IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF((VLOOKUP( A2,males,6,0)),"XX","")). I'm trying to use above to identify if A2 is on list names males by XX in results column. |
All times are GMT +1. The time now is 05:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com