Hello I am trying to create a vlookup formula that will allow me to return multiple values in separate columns based on one main value. I have attached a sample file that outlines what I am trying to accomplish. Thanks for the help.
Miami (Cell A2)
Return value from Sheet 2 Column A based on Cell A2
Return value from Sheet 2 Column B based on Cell A2
Return value from Sheet 2 Column C based on Cell A2
Return value from Sheet 2 Column D based on Cell A2
Return value from Sheet 2 Column E based on Cell A2
=IF(A2=0,VLOOKUP(A2,Data!$A$4:$E$15,2,FALSE))
Bookmarks