Image 2.jpg
I want to use column C and column D as the reference table. So I need helping looking up the requistion in column A and if it matches a requisition in column D, it will list the information tied to it from Column C in the B column.
Image 2.jpg
I want to use column C and column D as the reference table. So I need helping looking up the requistion in column A and if it matches a requisition in column D, it will list the information tied to it from Column C in the B column.
Last edited by Paul; 07-23-2012 at 03:19 PM.
Hello gblack6181, and welcome to the forum.
You can use INDEX() & MATCH() for that. Although you have multiple occurrences of the same #'s in col D it appears as though each occurrence relates to the same # in col C. So, in B2 and dragged down, try:
=IF(A2="","",INDEX(C:C,MATCH(A2,D:D,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks