Need to pull items from a list to another tab

**gaitkeeper** · 03-14-2014, 09:00 AM

Hi All,
I am trying to take items from a master list and pull them into different tabs based on a job number. For instance, if this is my master list:

Main Page.jpg

Based on the job number, I want the phone number and user name to pull into it's corresponding job tab.

3232.jpg

I know I can do this with VBA, but I'm wondering if there is a way to do it in formula.

Thanks in advance for any help you can provide!

**Fotis1991** · 03-14-2014, 09:04 AM

Hi

Take a look to INDEX & MATCH functions.

**AZ-XL** · 03-14-2014, 09:24 AM

Hi
It should be like that. You can modify it for yourself. But the logic is the same

=IFERROR(INDEX(Sheet2!$A$2:$E$21,SMALL(IF($B$1=Sheet2!$A$2:$A$21,ROW(Sheet2!$A$2:$A$21)-1,""),'3232'!$A3),MATCH(B$2,Sheet2!$A$1:$E$1,0)),"")

**gaitkeeper** · 03-14-2014, 02:28 PM

Thanks all! I decided to go VB after all. I wanted to know which ones had made it to each of the sheets, so I decided I could write a macro to copy the numbers into each page and then color them as they were added.