Here is a explanation of what I am trying to do. Anyone have any ideas on how to make this happen? Any advice would be greatly appreciated. Im sorry if this is confusing please let me know if I can be more clear on something.
If spreadsheet “X” has a value (example 280x) in column "B" that appears on spreadsheet “Y” in column "B" then import value from spreadsheet “Y” column “C” that is in the same row to the value in column “B” to column “C” in spreadsheet “X”.
In cell C2 of X, use
=VLOOKUP(B2,Y!B:C,2,False)
Assuming that your first value is in row 2.
If you have separate workbooks, then type
=VLOOKUP(B2,
and navigate to Y and choose the sheet and columns B:C of that sheet, then type
,2,False)
and press enter.
Bernie Deitrick
Excel MVP 2000-2010
Sir, I can not thank you enough. You have certainly made my day. If I may ask a follow up question. Is there a way when a matching value is not found to pull data from to have the formula insert a "0" instead of #N/A?
Thanks again
Of course.
Use the IFERROR Function
=IFERROR(VLOOKUP(B2,Y!B:C,2,False),"0")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks