LinkBack URL
About LinkBacks
I want to look at col B and Col C on sheet1 and if what is in col B and C is found on sheet2 in col A and col B (the same row) then I want to return the 3rd column (column C) on sheet2.
I want to look at col B and Col C on sheet1 and if what is in col B and C is found on sheet2 in col A and col B (the same row) then I want to return the 3rd column (column C) on sheet2.
Hi .
Be sure that best way to describe your problem is to upload a sample workbook.
Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.
To attach a small sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I don't think that is necessary. It might be an IF statement I need. Basically if sheet1 col B row i and col C row i match sheet2 col A row j and col B row j then return the value of whatever is in col C row j on sheet2.
As you believe.Originally Posted by ScabbyDog
Just to say that in Excel we don't use letters for the rows.
Good luck.
i and j are integers......
Can anyone help me out here?
sample1.xlsx
here is attached sheet with how I want data to look.
So try in D1 and copy down this ARRAY formula.
=IFERROR(INDEX(Sheet2!$C$1:$C$500,MATCH(B1&C1,Sheet2!$A$1:$A$500&Sheet2!$B$1:$B$500,0)),"")
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Thanks Fotis. Much obliged.
........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks