Hi,
Please can you try and help me with this one. I am normally comfortable with VLOOKUP but I'm a bit stuck on this one.
I would like the cells in column J (sheet 1) to turn green or display "Y" or "Yes" if there has been any entrys in column AG (sheet 2) relating to the purchase order number(s) in column I (sheet 1) & column V (sheet 2).
Is this possible or does it have to return and cell value?Sample.xlsx
Will something like the attached workbook do?
Hope this helps!
Spread the love, add to the Rep
"None of us are as smart as all of us."
Maybe =IF(COUNTIF(Sheet2!V:V,Sheet1!I4)>0,"Yes","")
Hi,
see if it help you..
If answer helped you say Thanks by Add Reputation
Hi Mate,
put this formula in sheet 1 "J4"
=IF(VLOOKUP(I4,Sheet2!V:AG,12,0),"Yes","")
Thanks so much chaps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks