Excel formula

[lvasquez3]

Ok-I have a spreadsheet like this:
Vendor-Inv #-Date-Amt Due and a second tab with all the vendor info like
name, phone # & Fax #. What formula can I use so that when I enter a vendor
name in the 1st tab it pulls the info I have from the 2nd tab and? And if
possible, if I change any info on tab 1, it will update on tab 2???? Please
help!

 

[Nobody]

Use VLOOKUP Function

 

[lvasquez3]

I really appreciate you responding...But I still don't understand the whole
VLOOKUP. Thank you for helping.

 

[Ragdyer]

Your example of the column headers on Sheet1 don't seem to match the data
you described in your vendor list on Sheet2, so you're not giving us any
pertinent information as to *exactly* what and where the values are that you
want to pull to Sheet1.

If you're looking for explicit formula help here, you'll need to describe in
a lot more detail, your data locations and labels and configuration.

 

[lvasquez3]

Ok-I have a Xl spreadsheet that I keep track of all my A/R customers...I have
a 2nd tab that has their Vendor Name-Contact Person-Number-Fax. Each time I
invoice a customer, I add them to this sheet (1st tab) But then I have to
click back to my 2nd tab to get the info (Contact, #, Fax) and enter it on my
1st sheet. So I want to know if there is a way for when I do add a customer
to my 1st sheet that I can just type in the customer name and it would
automatically bring over the other info from the 2nd tab...Does that make
more sense?

 

[RagDyer]

Couldn't you use your second sheet as a sort of "Master".
Make all your primary entries on that sheet, then, when it comes time to
invoice, enter their name on the first sheet, and have that first sheet
'pull' all the pertinent information from the second sheet "master".

Formulas (functions) *pull* data, they *cannot push* to another location.

If you can work with this premise, then Vlookup or Index and Match is what
you'll need.
Which formulas you use will depend on where the "key" to the datalist is
located, within the datalist.

If "Name" is the key, and it's in the first (left most) column of the
datalist, the Vlookup will work.
If it's anywhere else, you can use the Index and Match combo.

So, can you work with "pulling" data?

If you can, then post back with the location of your "key" in your
datalist.