VLookup function

Hey guys,

I am having a problem with the range of cells. I have a table which contains 836 record of cities and another table of 9 rows and 2 columns. The second table has the city name and its state. I would like to match that with the 836 records so i would have each city with state. This is sales sheet where we view customer city and state. I have used this formula VLOOKUP(A3,C3:D10,2,FALSE) but when I copy and paste for the next cell the cells range lookup increases. When this happens excel exits the lookup range and comes back with zero or the wrong state.

how can I make the lookup range fixed. Always C3:D10 and only the A column increases.

Thanks guys

Attach a sample workbook (not image). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

maybe you should use: VLOOKUP(A3,$C$3:$D$10,2,FALSE)

I tried with the dollar sign and it did work with fixing the lookup range but the states didnt correspond to the correct cities. here is the link to the sheet.
https://www.dropbox.com/s/r9boqfwlwa...tate.xlsx?dl=0

thank you so much.

ok uploaded

OMG works perfectly. THANK YOU SO MUCH

this formula works perfectly. THANK YOU SO MUCH. #lifesaver

So :
00repsolv.gif