IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

[boojooo]

Hello,

I am doing a vlookup between two workbooks in each of four cells (A3 - A6) based on the value in A1. In A2 I have 4 different options that get inputted, separate from these vlookups. What I would like to accomplish is to only show values in cells A3 - A6 based on the value listed in A2. So if A2 shows "10" then only the cell with the header "10" would populate and the other 3 would remain empty.

I think I need an IFERROR function, vlookup function, and something else so that whatever the draft size in A2 is it only populates the corresponding draft plu cell. I'm hoping I can do this without a macro.

 

[mole999]

what does your formula look like ?

 

[boojooo]

=VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$AE$27256,31,FALSE) in A3
=VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$AE$27256,32,FALSE) in A4
=VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$AE$27256,33,FALSE) in A5
=VLOOKUP(A1,[BeerDatabase1.xlsx]Sheet1!$A$3:$AE$27256,34,FALSE) in A6

I'm not sure how to what to input next.

 

[DanteAmor]

What do you mean by header "10"?
In row 2 you have headers and one of them is called "10"?

 

[boojooo]

That the values under the headers could change and one of them would be a "10". I was able to figure out the formula though:
=IF(H3=10,(VLOOKUP(B3,[BeerDatabase1.xlsx]Sheet1!$A$3:$AH$27256,34,FALSE)),"")

 

[DanteAmor]

That the values under the headers could change and one of them would be a "10". I was able to figure out the formula though:
=IF(H3=10,(VLOOKUP(B3,[BeerDatabase1.xlsx]Sheet1!$A$3:$AH$27256,34,FALSE)),"")

Perfect !, let me know if you have any doubt.