I am trying to return data from a sheet of data to fill in text boxes on a
form I made. I do this by using a =VLOOKUP and reference a RGA #. So my
equation looks like =VLOOKUP(J3,DATA,2)

Where J3 is the cell with my RGA #, DATA is the sheet i am looking in and 2
is the column to look for the info.

My problem is my RGA #'s are grouped by an invoice number. ex 1234-1,
1234-2, 1234-3, 1234-4 etc.

When I get to double 1234-11, it refers back to 1234-1. Is this an issue
with using VLOOKUP? As with 1234-12, 1234-13 etc, they all refer to 1234-1.

Any ideas?

Cheers,
Scott

Vlookup has 4 bits to it.
Use this
=VLOOKUP(J3,DATA,2,FALSE)

That false is basically an answer to the question "Is it good enough if I
just come close to what you want?" It never has been for me so I am always
putting false.

If that doesn't work come back again
--
Allllen


"scott" wrote:

I am trying to return data from a sheet of data to fill in text boxes on a
form I made. I do this by using a =VLOOKUP and reference a RGA #. So my
equation looks like =VLOOKUP(J3,DATA,2)

Where J3 is the cell with my RGA #, DATA is the sheet i am looking in and 2
is the column to look for the info.

My problem is my RGA #'s are grouped by an invoice number. ex 1234-1,
1234-2, 1234-3, 1234-4 etc.

When I get to double 1234-11, it refers back to 1234-1. Is this an issue
with using VLOOKUP? As with 1234-12, 1234-13 etc, they all refer to 1234-1.

Any ideas?

Cheers,
Scott

Works great! Thanks for your help!

"Allllen" wrote:

Vlookup has 4 bits to it.
Use this
=VLOOKUP(J3,DATA,2,FALSE)

That false is basically an answer to the question "Is it good enough if I
just come close to what you want?" It never has been for me so I am always
putting false.

If that doesn't work come back again
--
Allllen


"scott" wrote:

I am trying to return data from a sheet of data to fill in text boxes on a
form I made. I do this by using a =VLOOKUP and reference a RGA #. So my
equation looks like =VLOOKUP(J3,DATA,2)

Where J3 is the cell with my RGA #, DATA is the sheet i am looking in and 2
is the column to look for the info.

My problem is my RGA #'s are grouped by an invoice number. ex 1234-1,
1234-2, 1234-3, 1234-4 etc.

When I get to double 1234-11, it refers back to 1234-1. Is this an issue
with using VLOOKUP? As with 1234-12, 1234-13 etc, they all refer to 1234-1.

Any ideas?

Cheers,
Scott