marshybid
07-29-2008, 06:41 AM
Afternoon all,
Can anyone help me with how to write the VLOOKUP formula to be based on multiple criteria;
Example - Sheet 1, Column A contains a persons name, Column B contains an ID number, Column C contains a status
Sheet 2 Column A contains a persons name, Column B contains an ID number
ID numbers are not unique so for sheet 2 I would like to lookup the persons name (column A in sheet 1), if I find an exact match then see if the ID number in Column B also matches, if yes then insert sheet 1 Column C value into Column C in sheet 2
Help please :dunno
Marshybid
Can anyone help me with how to write the VLOOKUP formula to be based on multiple criteria;
Example - Sheet 1, Column A contains a persons name, Column B contains an ID number, Column C contains a status
Sheet 2 Column A contains a persons name, Column B contains an ID number
ID numbers are not unique so for sheet 2 I would like to lookup the persons name (column A in sheet 1), if I find an exact match then see if the ID number in Column B also matches, if yes then insert sheet 1 Column C value into Column C in sheet 2
Help please :dunno
Marshybid