LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DS DS is offline
external usenet poster
 
Posts: 117
Default Need help with Vlookup with and IF statements

I have two sheets in the same workbook. Master and New.

Masters 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 IFs
for B and C.

There is no unique field, it has to match 3 fields.

Any help is GREATLY appreciated.

Dave

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup with AND, OR IF statements Novawitt Excel Worksheet Functions 1 November 18th 09 11:51 AM
VLOOKUP and IF Statements cranen Excel Discussion (Misc queries) 2 August 13th 09 10:26 PM
Using Vlookup with IF statements Addy Excel Programming 3 April 13th 07 04:35 PM
Using Vlookup for IF statements Addy Excel Programming 3 April 13th 07 04:17 PM
Help with Vlookup and If Statements SunnyM Excel Discussion (Misc queries) 4 February 9th 06 12:45 AM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"