Conditional VLookup

Hi Experts
I have a table in which I am doing a simple vlookup to populate the cell

=VLOOKUP([@[Product No]],CategoryData,3,FALSE)

It works, but now I need to make it conditional

I have another column in the table called [@[Outsourced/Cancelled In SAP]] and need the formula to check this cell first

IF([@[Outsourced/Cancelled In SAP]]=C, then Cancelled
IF([@[Outsourced/Cancelled In SAP]]=OS, then Out Sourced
IF([@[Outsourced/Cancelled In SAP]]=NA, then Non Assembled
If not, do the VLOOKUP([@[Product No]],CategoryData,3,FALSE)

Any help, please

Thanks
Rahul

Hi Rahul- perhaps this:

Formula:

Please Login or Register  to view this content.

If you have your answer, please mark the thread as SOLVED (Thread Tools up top)...and perhaps click the Add Reputation star below any posts you found helpful. Thanks!-Lee

Hi TMS
Thanks a lot
It works like a charm

Appreciated

Hi Leelnich
Your solution also works like a charm
Thanks