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" wrote:

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"lvasquez3" wrote in message
...
I really appreciate you responding...But I still don't understand the
whole
VLOOKUP. Thank you for helping.

"Nobody" wrote:

Use VLOOKUP Function

"lvasquez3" wrote:

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!