You could add an additional (hidden?) column in Master that is a
concatenation of A, B, and C. Then you could do the VLOOKUP on that
column.
=CONCATENATE(A1,"|",B1,"|",C1)
OR do it in a VBA macro.
D-C
DS wrote:
I have two sheets in the same workbook. Master and New.
Master’s data will be similar to that of New, EXCEPT, Master will have an
additional column of notes, cell H, that is not in sheet New.
I need to copy the notes column from sheet Master H to New H
But to find the proper row it has to match criteria in 3 cells.
Criteria are cells A B and C.
So I am thinking, use VLookup for A but how do I also include the AND IF’s
for B and C.
There is no unique field, it has to match 3 fields.
Any help is GREATLY appreciated.
Dave
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----