Vlookup across different tables

[oliverexcel]

Hi there,

I would greatly appreciate any help.

I have got two tables. Table 1 contains a selections of ID's (e.g. 3,4,7,42,86) and the second tables contains all the projects ID's (1,2,3,4,5,6...etc) with a type of flower next to it associate with it. I was wondering how I can use Vlookup to make a column next to the ID's in table 1 in order to have flower next to each ID (e.g. 3 - Daffodil, 4 - Diasy). Some flowers are assigned to more than one ID, not sure if that changes anything.

Thank you very much,

Oliver

[Special-K]

When you say a flower next to it you mean the name of a flower, not a picture of a flower?

You'd need a table of IDs and the name of the associated flower then just VLOOKUP the ID and extract the value in the second column which would be the flower, e.g.

=VLOOKUP(A1,Sheet2!A$1:B$50,2,0)

Given an ID in A1 this would extract the name of a flower from column 2 of the ID/Flower table

[oliverexcel]

Hi Special-k,

Thank you for your response.

Just the name and not a picture.

My issue is that I'm looking for the type of flower for the first table so that requires using a vlookup to find the ID in the second table and then find the flower type next to that. Is that possible?

Best,

Oliver

[Special-K]

Like this?

See Sheet1, column B for the formula

UPDATE: Having trouble uploading the file...I cant seem to upload files dunno why.

in Sheet2
column A put your IDs
in column B put the names of the flowers

In Sheet1
column A put your IDs
in B1
=VLOOKUP(A1,Sheet2!A$1:B$50,2,0)
and copy down the column

Sheet1 column B will now have the name of the flower youve assigned to each ID

[oliverexcel]

That works! Thank you very much. I really appreciate it.