VLOOKUP question

  • Thread starter Thread starter WarDeathAngel
  • Start date Start date
W

WarDeathAngel

Hey,

I have a cell with a dropdown menu done with validation.
It refers to a list in Sheet 2 of ID's. Each ID has its ow
description.

The question is, is there a way to check what is the ID in th
validation cell and check in Sheet 2 what is its description, to the
write it in a cell in Sheet 1. And I have different sorts of ID
different companies.

Let say one company ID has the column B, and their description in C
and another company has its ID in D and the descriptions in E, and s
on. I know how to make for only one company

=VLOOKUP(B9,Sheet2!$B$1:$C$22,2,FALSE)

But how can I make it work for the 2 or more companies ?

I hope I've been clear enough

Thanks in advance

WD
 
Hi
an how do you want to output these different companies on your sheet 1
(combine them in one cell?)
 
Back
Top