Using Vlookup or Hlookup in one workbook to get data in another

[superboy]

Workbook1.xlsxWorkbook2.xlsx

Hello,

I have attached an example of 2 workbooks I have. I am trying to use vlookup or hlookup to get the Status cell data that's in workbook2 to appear under the corresponding Status name in workbook1.

I'm not sure If I made sense but if you look at my workbooks you might get what I'm trying to do. The vlookup function I have in workbook1 is wrong and I basically need help on it.

[AlKey]

In book1 cell B2


=IFERROR(INDEX([Workbook2.xlsx]Sheet1!$B$2:$E$2,MATCH(A2,[Workbook2.xlsx]Sheet1!$B$1:$E$1,0)),"")


OR HLOOKUP

=HLOOKUP(A2,[Workbook2.xlsx]Sheet1!$B$1:$E$2,2,0)

[superboy]

That's awesome. Thank you.

I used Hlookup because it seems easier for excel to compute.
I added IFERROR to get rid of the N/A.

=IFERROR(HLOOKUP(A2,[Workbook2.xlsx]Sheet1!$B$1:$E$2,2,0),"")

[AlKey]

You're welcome and thank you for your feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).