N/A Error in Excel

[Eamon2012]

In R26:R80
0.140
0.164
0.094
0.140
0.129
0.193
etc.

In AC19:AD534
0.320 85/40
0.319 9/4
0.307 5/2
0.285 11/4
0.266 3/1
0.249 100/30
etc.
In T26:T80 i have this formula...=VLOOKUP(R26:R80,AC19:AD534,2) but i am getting the N/A error how do i fix this please?

[vandan_tanna]

I would think you need =vlookup(R26, $AC$19:$AD$534,2) in T26 and then copy down

[Eamon2012]

I would think you need =vlookup(R26, $AC$19:$AD$534,2) in T26 and then copy down

Thank you, but i am still getting the same error "N/A"

[Eamon2012]

File Attached

[Ace_XL]

Use

=vlookup(R26, $AC$19:$AD$534,2,FALSE) for an exact match, else Excel will pull up closest results that match

[Eamon2012]

Use

=vlookup(R26, $AC$19:$AD$534,2,FALSE) for an exact match, else Excel will pull up closest results that match

Thank you, but still getting N/A

[vandan_tanna]

may be you can upload your file so we can guide you better...

[Ace_XL]

Please upload a sample worksheet, would be easier to resolve!

[vandan_tanna]

Ace_XL: nice to be on the same wavelength as you

[Ace_XL]

The range that you are looking up from is rounded to 3 decimal places only. Hence, use the below

=VLOOKUP(ROUND(R26,3), $AC$19:$AD$534,2,FALSE)

[Eamon2012]

The range that you are looking up from is rounded to 3 decimal places only. Hence, use the below

=VLOOKUP(ROUND(R26,3), $AC$19:$AD$534,2,FALSE)

Thank you, much appreciated

[smls]

My bad, something got deleted when I opened it