adding a round function to an existing formula

D

Deb Paiement

The value in some of the fields to look up are decimals.
EX: The result in the field is 5.6. The lookup is seeing this as 5 instead
of 6. My formula is below. I am somewhat new to


=IF(ISERROR(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))=TRUE,"",(VLOOKUP(D5,'LOOKUP
TABLES'!$A$3:$D$13,2))*0.25)
 
F

Fred Smith

Vlookup will take results of calculations as easily as a cell address. Use:

=IF(ISERROR(VLOOKUP(round(D5,0),'LOOKUP
TABLES'!$A$3:$D$13,2)),"",VLOOKUP(round(D5,0),'LOOKUP
TABLES'!$A$3:$D$13,2)*0.25)
Click to expand...

Regards,
Fred
 
D

Deb Paiement

Worked great! Thank you!

Fred Smith said:
Vlookup will take results of calculations as easily as a cell address. Use:

=IF(ISERROR(VLOOKUP(round(D5,0),'LOOKUP

Regards,
Fred
Click to expand...
 

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

How to get a blank cell instead of a "0" 2
Using ISNA on more than one column within an If Function 2
Vlookups to return a N/A value 3
Adding ISERROR to formula 3
Formula Result is "V6", need Excel to use cell "V6", not the resul 3
Array formula using sumproduct & vlookup 6
Reference function from an out of sort table 5
Error in if condition 1

Top