VLOOKUP Return Value based on 2 Columns, One may be blank

**kevinmcmanus** · 08-17-2016, 02:46 PM

Hi,

I'm trying to do a simple VLOOKUP on 2 different Columns. If it finds the value in the 2nd column, return the value in the 3rd column. If 2nd column is blank, go to 1st column LOOKUP & return value in 3rd column.

See attached file.

Mac

**Neil_** · 08-17-2016, 03:34 PM

=IFNA(VLOOKUP('Raw Data'!B2,'Contract Type Table'!B:C,2,FALSE),VLOOKUP('Raw Data'!A2,'Contract Type Table'!A:C,3,FALSE))

**kevinmcmanus** · 08-18-2016, 09:30 AM

That worked like a charm, thanks! I did get some #N/A values but, that's because my Reference Table is incomplete. Easy fix. Thank you!

**Neil_** · 08-18-2016, 11:38 AM

You're welcome!
Please mark the thread 'Solved' using the thread tools link above your first post. Don't forget to add rep if you are happy with the solution!

VLOOKUP Return Value based on 2 Columns, One may be blank

LinkBack

Thread Tools

Rate This Thread

Display

VLOOKUP Return Value based on 2 Columns, One may be blank

Re: VLOOKUP Return Value based on 2 Columns, One may be blank

Re: VLOOKUP Return Value based on 2 Columns, One may be blank

Re: VLOOKUP Return Value based on 2 Columns, One may be blank

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VLOOKUP - If table array is blank, need it to return blank

[SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP

Using vlookup to return single value based on calculations of other columns?

How do I return a blank for VLOOKUP instead of #N/A?

[SOLVED] How do I return a blank for VLOOKUP instead of #N/A?

How do I return a blank for VLOOKUP instead of #N/A?

How do I return a blank for VLOOKUP instead of #N/A?

Bookmarks

Bookmarks

Posting Permissions