G
Guest
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
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