VLOOKUP based on drop down list

[ipbr21054]

Hi,
I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is.
Here is the info for you.

Worksheet is called TEST
Drop down list is in column B
Cells awaiting data are in column C, D, E
Table database is on same worksheet & range is N4:Q21
Find name in column N
First value to look at is in column O
Second value to look at is in column P
Third column value to look at is in column Q

So It would work like this,
Cell B5 select name from drop down list.
Look for that name in column N of table database.
Once found get value from column O,P & Q
Then put that value in Row 5 column C,D & E

 

[alansidman]

[table="class:thin_grid"]
[tr][td]v[/td]
[td="bgcolor:#ECF0F0, align:center"]C[/td]
[td="bgcolor:#ECF0F0, align:center"]D[/td]
[td="bgcolor:#ECF0F0, align:center"]E[/td]
[/tr][tr][td="bgcolor:#ECF0F0, align:center"]1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]2[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]3[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]4[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]5[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]=VLOOKUP($B$5,$N$4:$Q$21,2,0)[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]=VLOOKUP($B$5,$N$4:$Q$21,3,0)[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]=VLOOKUP($B$5,$N$4:$Q$21,4,0)[/td]
[/tr]
[/table]

 

[ipbr21054]

Hi,
Yes that works.

Before i select from the drop down list colmns C,D & E show #N/A until i make a drop down selection.
Need to be able to show the cell is blank without the #N/A

Im not sure the correct way to write it but did the following & now i see #NA ME?

=IFERROR(VLOOKUP($B$5,$N$4:$Q$21,3,FALSE),””)

 

[ipbr21054]

Hi,
This gives me a blank cell but is it correct & ok to use ?

=IFERROR(VLOOKUP(B5,$N$4:$Q$21,2,0),"")

 

[alansidman]

If it works, then why wouldn't it be ok. Afterall, it is your spreadsheet and you are the one that needs to be happy.