Check input for existence then pull corresponding data

**msaz87** · 10-07-2008, 02:34 AM

Hi all,

Here's what I'm looking to do:

The workbook will consist of at least two pages:
1. A user input page
2. A records page

On the user input page, there will be two fields to enter information in... one for an exact address (ex: 600 n. nowhere) and one for a casual address (ex: On Nowhere street south of Anywhere Blvd).

On the records page, I'm going to keep all the addresses and their corresponding casual addresses so that in the future, I don't have to keep inputting both.

What I'm looking to do is have a formula/function/vba code check the exact address against my records for it already existing -- and if so, pulls the corresponding casual address.

For example, if last week I entered 600 n. nowhere and then transferred it into my records and then this week, I again entered 600 n. nowhere, the workbook would find the record and place the casual address for me.

Is this feasible?

Thanks.

**Richard Schollar** · 10-07-2008, 03:55 AM

Hi

Assuming the address is within a single cell (in col A), and the causal address is within an adjacent cell (in col B) and all your addresses are in A & B columns (say) of sheet Record then you can use a VLOOKUP in the Input sheet:

=VLOOKUP(A1,Record!A:B,2,0)

which will match the accurate address entered in A1 against the accurate address in col A of sheet Record and return the corresponding casual address in col B.

Note that a #N/A will result if the address is not found. if you would prefer an alternative warning of your own making, you can wrap it in an IF:

=IF(ISNA(VLOOKUP(A1,Record!A:B,2,0)),"Your own warning here",VLOOKUP(A1,Record!A:B,2,0))

Richard