# VLOOKUP Function Problem

#### JJL

##### New Member
I am having some difficulty using the VLOOKUP function. I am trying to use the value on Sheet "IMR 700-X", Cell F2 as the value I am trying to find in my table on Sheet "IMR" Range A1:B27. There may not be an exact match on Sheet 2 so I want it to return value that is closest (but less).

Sheet "IMR 700-X" Cell I2 contains this formula:
=VLOOKUP("F2",IMR!\$A\$2:\$B\$27,MATCH("700-X",IMR!\$A\$1:\$B\$1,))

This formula works. It does return the correct value. When I try to copy the formula down the row (to I100) it fails. I have changed the "F@" manually to "F3" and so on to no avail.

Please, can anyone help. This is just making me crazy.

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### jeffreybrown

##### Well-known Member
Not sure your formula makes sense to me without seeing some data, but also don't understand why you have "" around the F2 unless F2 is not referencing a cell and it is considered text.

Replies
11
Views
396
Replies
7
Views
1K
Replies
5
Views
402
Replies
24
Views
1K
Replies
1
Views
2K

1,191,529
Messages
5,987,116
Members
440,080
Latest member
drhorn4908

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back