View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Celia Celia is offline
external usenet poster
 
Posts: 19
Default vlookup function

I am trying to pull data from a list of items. I think I am trying to use a
nested vlookup but maybe not or maybe an array formula. If there is match
with column A & Column B I need Column J data. How do I achieve?

The worksheet is setup as follows:
In Column A I have a list of item numbers and there is more than one of the
same number. They are sorted in numerical order.

In column B, I also have numbered items Ex. If Column A has item#1 three
times. Column B has those three items numbered from 1 to 3.

how do I get data from Column J when the criteria for what is in column A is
met and column B is met - maybe a nested if array?

HELP!!!!
--
Celia