Hi I am a little confused as how to do this but as you can only use upto seven nested IF() im pretty sure it must be Vlookup.
In Products worksheet I have columns
A B
Description Brand
and in Info worksheet I have column A
A
Available Brands
(a list of brands)
I would like to use a function to search the description field for one of the brands in the info worksheet and to then display that brand in column b on the products worksheet.
I have got as far as
ISNUMBER(SEARCH(XXX,XXX))
but then i am completly confused as how to use vlookup or ........
Any help will be greatly appeciated
Ashley
Bookmarks