Hi everyone
I have a problem that I think Index Match will help me with but I'm not 100% sure
In the attached spreadsheet, this is what I need:
If the value in Column A is found in Column C, it copies the price value in Column D into the right place in Column B alongside the correct reference.
Thanks in advance!
Cheers
Enter this formula in B2 and copy down
=IFERROR(VLOOKUP(A2,$C$2:$D$556,2,0),"")
Did this work for you?
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
Hey
Thank you so much this worked perfectly...
Cheers
Barry
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).
Hey
Thanks again
Could you explain what that formula means / does?
Just so I can learn....it's going to be very handy for me going forward! But I would like to learn what it does.
I've used VLOOKUP before but not the other function and obviously not both combined!!
Cheers
Barry
The IFERROR just tells Excel that if that if there is an error or no data; so you don't get an #N/A message, to leave the result empty, which is the empty double quotes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks