VLOOKUP
=VLOOKUP(A1,pricing,COLUMNS(pricing),FALSE)
columns(pricing) returns you the amount of
columns of the range you enter.
this should work, if pricing is a global range.
if pricing is a sheet range you need to enter:
"sheet1!pricing" instead of just "pricing"
where you change sheet1 to your sheet.
hth
Carlo
|