Adding Mapping Rule to VLOOKUP

[meppwc]

Is it possible to display values in adjacent cells if and only if a value is found in a table?

The formula below is located in cell C2 of the ProjectModel worksheet and it works correctly
=IFERROR(VLOOKUP(A2,Available!A:A,1,FALSE),"")
If the value in A2 is not found in the "Available" table, then "ProjectModel" C2 is blank. But if a value is found in the "Available" table, the value found is displayed in "ProjectModel" C2. This is all perfect.

What I am hoping to do is add additional mappings if, and ONLY if, a value is found.
For example
Lets say that the formula above in C2 of ProjectModel is also found in cell A45 of the of the "Available" table.
Cell C2 will populate with the value found in A45 of the Available table.
If that happens then I would like cells C3, D3 and E3 to populate with the values found in B45, C45 and D45 of the "Available" table

Cross posted https://www.excelforum.com/excel-for...o-vlookup.html

 

[jmacleary]

Hi there - these should do it:

C3 would need to be: =IF(C2<>"",IFERROR(VLOOKUP(A2,Available!A:B,2,FALSE),""),"")
D3 would need to be: =IF(C2<>"",IFERROR(VLOOKUP(A2,Available!A:C,3,FALSE),""),"")
C3 would need to be: =IF(C2<>"",IFERROR(VLOOKUP(A2,Available!A:D,4,FALSE),""),"")

 

[meppwc]

TY so much