Referencing a Rounded number in a LOOKUP command

S

sCOTT

Hello,

I have a cell that is rounding up another cell. Let's call that cell A1. I
have another cell that is looking up the rounded cell, A1, but it is not
outputting the correct number from the referenced table. The look-up array
and output array are both correct. I tested this same command in a separate
file and it works just fine. Also, when I simply input an actual number in
cell A1, my lookup command works fine.
 
S

Sheeloo

=VLOOKUP(A1, C:D,2, False)

If D has numbers before rounding then use A1 without rounding,
 

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

Creating a Search using a combo box and then creating a report. 4
lookup command 1
If Function neglecting 0 as a number 1
lookup and return column number 2
Paragraph numbering in Word 1
why is answer rounded up? 1
How to create absolue path link to another workbook (Excel 2003) 1
How To Have A Cell Be Blank If... 2

Top