I don't understand your layout very well but if your table is in, say A2:B10 on sheet 2 you can fetch the number using VLOOKUP like

I am very inexperienced with v look up...but that might work.


basically on Sheet 1 I am going to have a cell that will pull a contact name......from sheet two. and plug it into D6 on Sheet 1

The Name list on sheet to is in column A (1 to whatever)

The Number List is on Sheet 2 in Column B (1 to whatever).....each number should go to the name on that row.....so the name on A1 goes to the number on B1....and so on

So once I select a name to be plugged into D6....I want to have the matching phone number pull to cell H6 on sheet one.


Can you write the correct V look up for that?......and the other question or issue is, that the info on sheet 2 is a list.....and I want D6 to basically just go and find the phone number on sheet 2 and plug it in based on the name that is put in D6

Thanks