vlookup won't work on a formula cell

Hi ,

My lookup Value cell has a fomular that gives me the average of certain fields. What the VLookup does is , if the average is a certain number then populate a certain on the Vlookup cell.

My problem is that if I manuall enter the average on the my lookup value cell, then the vlookup works fine, however if I try to get the average from a fomular Vlookup comes back as “N/A”..

Thanks,
LL

You'll probably find that the average formula is returning a number with several decimal places, like 12.3456 or something.
but you have the cell formatted to only show 2 decimal places, so it appears to be rounded to 12.35
But the Vlookup is looking at the entire value with several decimals, not just the formatted value.

That's why it works when you manually type the value, but not by the result of the formula.

You are correct it has several decimal places... How can i work around this.. Plus I cant share the sheet since im at work.

Originally Posted by Jonmo1

You'll probably find that the average formula is returning a number with several decimal places, like 12.3456 or something.
but you have the cell formatted to only show 2 decimal places, so it appears to be rounded to 12.35
But the Vlookup is looking at the entire value with several decimals, not just the formatted value.

That's why it works when you manually type the value, but not by the result of the formula.

If the data in your lookup table is sorted ascending on the leftmost column, then Use TRUE as the 4th argument in the vlookup.

Thanks a Million.. it worked

Great, glad to help.