vba WorksheetFunction Lookup(2,1/Countif(........))

It is a lot better to post a sample work sheet.

however.

Lookup format is = LOOKUP( value, lookup_range, [result_range] )

So you are looking for the value 2

Your Range to look in is: 1/(WorksheetFunction.COUNTIF(Sheet8.Range("B3:B351"). ie 1 ( what is the 1 doing? = Error ) / Error = Error

CountIf format =COUNTIF (range, criteria). You have a range but no criteria


There is more but that is enough to be getting on with.




Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Please Login or Register  to view this content.

I honestly don't know. After you get so far.. It is only trial and error.

I will see if I can the rng to work

Please Login or Register  to view this content.

Thanks, it would great to get the rng to work. I also try making the range into a table and the formula works on table/field name like this x = Application.Evaluate("=LOOKUP(2,1/(COUNTIF(ID[ID],"">""&ID[ID])=0),ID[ID])")
strange