Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=vlookup question | Excel Discussion (Misc queries) | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |