Forum Discussion
Solved
Lookup data in table and insert various columns into row in worksheet
I want to have a dropdown list from a table created from a supplier that shows in a row with a description but also an item number and a rate in various columns in the table. I can get the descripti...
=IFERROR(VLOOKUP(B2,'Current Support Items'!$B$2:$I$8,8,FALSE),"value not found in column support item name")You can try this formula in cell K2.
=IFERROR(INDEX('Current Support Items'!$A$2:$A$8,MATCH(Quote!B2,'Current Support Items'!$B$2:$B$8,0)),"value not found in column support item name")You can try this formula in cell A2.
=IFERROR(VLOOKUP(B2,'Current Support Items'!$B$2:$I$8,8,FALSE),"value not found in column support item name")You can try this formula in cell K2.
=IFERROR(INDEX('Current Support Items'!$A$2:$A$8,MATCH(Quote!B2,'Current Support Items'!$B$2:$B$8,0)),"value not found in column support item name")You can try this formula in cell A2.
Thanks very much. It worked fine!