Hi,
I have a list of products in column A, a separate list of products in column C and the prices of the products in column C in column D. (Hope this makes sense so far!!) I need to find the products that appear in both column A and column C and also assign the correct prices from column D. Can this be done? Any advice greatly appreciated.
Thanks,
Mark.
Where should the prices of the matched items appear?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
In Column E
=IF(ISNA(VLOOKUP(C2,$A$2:$A$5,1,FALSE)),"",D2). See attached
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi
Please see attached sample worksheet.
Hope it helps.
Good luck
Tony
PriceCheck2003.xls
Thanks Tony. That is exactly what I was after. Thanks to Ace_XL and arlu1201 aswell. Really appreciate the help guys.
Thanks,
Mark.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks