Seamus2626
asked on
vlookup
=IF(VLOOKUP(H2,'Region Mappings'!$AC:$AC,1,0),"Sy stem Issue","")
This is returning #NA - My mind is blank, why isnt it returning blank like im asking it to?
Thanks
Seamus
This is returning #NA - My mind is blank, why isnt it returning blank like im asking it to?
Thanks
Seamus
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is returning NA because a value was not found as you have the the range_lookup set to false (i.e. 0). refer http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
ASKER
Thanks!