[RESOLVED] Been away to long, need help

[mekinnik]

I have been away for programming Excel spreadsheets for so long I cannot remember how to programmically make the spreadsheet compare to cells. I am looking to do what I think is a VLOOKUP, I just do not know how to do it.

I have a very simple spreadsheet that is laid out as such.

column 'A' holds numerical values as texts (I did it this way in order to show the '0' that some values have as the first digit).
column 'B' holds names that correspond to the values of column 'A'

I am looking to speed the data entry part of this spreadsheet, therefore, I want to just enter the values into column 'A' and have the name auto populate column 'B'. In columns 'F' and 'G' beginning at row 2000 I have listed all the values and names. I am looking to compare the value I enter into column 'A' row whatever with that of column 'F' rows 2000-2703 and if a match is found enter the name from column 'G' into column 'B'.

Here is an example:
If at 'A:3' I enter the value '12345'
I than want to programmically compare the value of 'A:3' with that of 'F:2000 - F:2703', If a match is found at 'F:2504'
Then I want the name from 'G:2504' to be entered into 'B:3'

I hope this is understandable.

[Hack]

Welcome to the forums

Does this help?

[Siddharth Rout]

Welcome to the forums

Vlookup is explained very clearly with an example in your Excel Help

[mekinnik]

I do not have access to microsoft online help, I am on a secure server that has that blocked.

[Siddharth Rout]

It is an offline help. If you press F1 then it will automatically appear

[mekinnik]

Thank you