Put in the formula bar:
=IF(A3="","",VLOOKUP(A3,A4:$J$10,{3,4,5,6,7,8,9,10 },0))
A typo "correction" for the table array cell reference ..
and a slight revision to add TRIM() for robustness ..
Put instead in the formula bar with C3:J3 selected:
=IF(A3="","",VLOOKUP(TRIM(A3),$A$4:$J$10,{3,4,5,6, 7,8,9,10},0))
and array-enter as before
Another better but slightly longer alternative which returns say, : "-" for
any unmatched cases instead of ugly #N/As [where the input in A1 doesn't
match with what's in A4:A10]
we could put in the formula bar with C3:J3 selected:
=IF(A3="","",IF(ISNA(MATCH(TRIM(A3),$A$4:$A$10,0)) ,"-",VLOOKUP(TRIM(A3),$A$4
:$J$10,{3,4,5,6,7,8,9,10},0)))
and array-enter as before
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|