Basavaraj K H
Member
Dear All
I have a Stock Master file were all the list of stock is there (sold and unsold) .
I have sales register where i keep sold files data .
every stock has a unique code
now i want to see in stock master file what all stock are sold and what all are unsold
the results should be either "SOLD" or "UN SOLD"
I used vlookup in if condition and got correct value for Sold item , but getting #N/A in place of "UN SOLD" stock
i dont want to use IFERROR function ,,
Is there any solution Available
I have a Stock Master file were all the list of stock is there (sold and unsold) .
I have sales register where i keep sold files data .
every stock has a unique code
now i want to see in stock master file what all stock are sold and what all are unsold
the results should be either "SOLD" or "UN SOLD"
I used vlookup in if condition and got correct value for Sold item , but getting #N/A in place of "UN SOLD" stock
i dont want to use IFERROR function ,,
Is there any solution Available