Hi,
I've attached my spreadsheet.
I simply want to know which items in 'Sheet 1' are also in 'Master' using VLOOKUP in the J column of 'Master'. Can someone help me please? I'm struggling.
Thanks in advance.
Hi,
I've attached my spreadsheet.
I simply want to know which items in 'Sheet 1' are also in 'Master' using VLOOKUP in the J column of 'Master'. Can someone help me please? I'm struggling.
Thanks in advance.
which values are identic.
Which values should be found in your data?
edit:
J318 =match(D318,Sheet1!$C$2:$C$242,0)
Last edited by oeldere; 08-25-2016 at 11:28 AM. Reason: edit
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Sorry, vital info I neglected to include.
Column D in both worksheets.
Try this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Yes, your description is vague...
Taking a guess, you want to test if the value in Master Column D exists in Sheet1 Column C
Try this in Master J2 and filled down.
=ISNUMBER(MATCH(D2,Sheet1!C:C,0))
Try
=IFERROR(IF(MATCH(Master!D2,Sheet1!$C$2:$C$250,0),"Yes",""),"")
will return YES if match found
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks