r. venkataraman

[Jaladino]

Thanks,

And what if I want to have it blank if no entry is made in the relavent cell
(instead of N/A #)

 

[Max]

Extending further what R.Venkataraman suggested in your earlier post
(btw, you should have stayed within the same thread, otherwise your post
here would not make much sense <g>)

You could try instead in C21:

=IF(ISNA(MATCH($B21,$J$21:$J$37,0)),"",VLOOKUP($B21,$J$21:$L$37,COLUMNS($A$1
:A1)+1,FALSE))

The above will return the product description in C21 for the product code in
B21. Any unmatched product codes in B21 will return blank: "".

If you also want to likewise return the price for the product code in B21
in D21, just copy C21 across to D21, then format D21 as currency

And if you have yet other product codes in B22, B23, etc
just select C2121 and fill down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

Thanks,

And what if I want to have it blank if no entry is made in the relavent cell
(instead of N/A #)

--- pasted from earlier thread --------