View Single Post
  #1   Report Post  
Stepper Stepper is offline
Junior Member
 
Posts: 5
Question COUNTIF and VLOOKUP in one formula

Using the attached table as an example....

I'm using a VLOOKUP formula to return the values in column I, however, I only want the values returned if there are 3 or more values in columns B-H. If there are less than 3, I want "NA" returned.

I've tried a few variations, including putting a COUNTIF formula in column K to determine whether there are 3 or more values, then incorporating that column into the VLOOKUP, but I can't get this to work either.

Can anyone help? I've been stuck on this for days.
Attached Files
File Type: txt table example.txt (137 Bytes, 254 views)

Last edited by Stepper : November 3rd 10 at 02:07 AM Reason: Table not displaying correctly