lookup returns zero or the wrong number

M

Miree

"=IF(RC[-2]="""","""",IF(R[-13]C[-2]=""WBM"",LOOKUP(R[11]C[-2],Densities!C[-5],Densities!C[-4]),LOOKUP(RC[-2],Densities!C[-1],Densities!C)))"
Range("H21").Select
Selection.AutoFill Destination:=Range("H21:H39"), Type:=xlFillDefault
Range("H21:H39").Select
Range("H21").Select
End Sub
 
M

Miree

Sorry selected post before writing my question, please see question titled
lookup not working

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup not working 2
lookup vba 2
look up formula 4
same macro on multiple sheets 4
macro to copy rows that contain a cell with a certain number 2
Autofill Function 1
Vlookup in vba - how to use absolute rows not relative 1
Macro that deletes and pastes filterd rows and then some 2

Top