Combining IF Statement and Vlookup

Jun 12, 2017
Reaction score
I am trying to combine a if statement with a vlookup. I have original data on first tab "CSV Detail", I need to vlookup some the of data to a second tab "Worksheet".

This is what I am trying to get done is if "CSV Detail" FB is zero then I want a zero in the "Worksheet" column. But if there is an amount in FB then I want the value from the vlookup

I tried this but it returns a zero no matter what FB is
=IF('CSV Detail'!FB5=0,0)*VLOOKUP($B6,'CSV Detail'!$D$2:$GL$804,164,FALSE)

An example FB =0 ADJ=301.68 then I want ADJ to be zero
But is FB = 600 and AJD = 301.68 then I want ADJ to be 301.68

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