MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP - display only if criteria met


Posted by Connie on June 07, 2001 12:47 PM

This is probably simple but...
Is it possible to be looking up a value (i.e. A1=VLOOKUP(C8,Table,14,FALSE) but display the result of the lookup only if it meets certain criteria? For instance, I only want the result to show in A1 if the result of the lookup is >=5. If it's less than that, I just want A1 to remain blank.
Any suggestions appreciated.


Posted by Barrie Davidson on June 07, 2001 12:50 PM

Change your formula to:
=IF(VLOOKUP(C8,Table,14,FALSE)>=5,VLOOKUP(C8,Table,14,FALSE),"")

Posted by Connie on June 07, 2001 12:53 PM

Thanks, Barrie, for the quick response!!

Posted by Aladin Akyurek on June 07, 2001 12:55 PM

Hi Connie

=IF(VLOOKUP(C8,Table,14,FALSE)>=5,VLOOKUP(C8,Table,14,FALSE),"")

You seem to carry out an exact match [that is, what FALSE (or 0 in the stead) directs Excel to do]. If an exact match is not required, you may omit the 4th arg of VLOOKUP.

Aladin

Posted by Connie on June 07, 2001 1:57 PM

Thanks, Aladin!

Hi Aladin,
I hope it doesn't look like I was ignoring your response. Your answer showed up after Barrie's.
Regards,
Connie