So, I can’t figure out how to make this work.
I need Column "F" on sheet 2 to show the value of Column "I" on sheet 1 when column "A" on sheet 2 matches column "J" on sheet 1 ; columns "I" and "J" on sheet 1 coincide with different values.
Something like a combination of the following; sheet2!A:A=sheet1!J:J "then" sheet2!F:F=sheet1!I:I.....
Just don't know how to write it...
Sounds like you're looking for an index/match sort of thing. What do you want to happen if the value in A (sheet2) isn't in J (sheet1), "N/A", blank, some other value?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It is all based on work-center numbers and their hourly billing rate. I really wouldn't need it to specify.
So assuming that will never happen and you're looking for exact matches
=INDEX(Sheet1!$I$2:$I$500, MATCH(A2, Sheet1!$J$2:$J$500,0))
If this isn't working, try attaching a workbook showing what you have (Go Advanced>Manage Attachments)
Genius! Problem solved! I will be able to edit my exact column values...but that is the formula that I needed.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks