ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Best formula to use?? (https://www.excelbanter.com/excel-discussion-misc-queries/178408-best-formula-use.html)

paulza

Best formula to use??
 
what i'm wanting, I have a spread sheet of a phone bill, detailing number
called, date, duration, etc and i want excel to match the phone number dialed
to a list of people in a seperate document/sheet, which is the best formula
to use?

Don Guillett

Best formula to use??
 
Politics?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"paulza" wrote in message
...
what i'm wanting, I have a spread sheet of a phone bill, detailing number
called, date, duration, etc and i want excel to match the phone number
dialed
to a list of people in a seperate document/sheet, which is the best
formula
to use?



Bob Phillips

Best formula to use??
 
VLOOKUP


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"paulza" wrote in message
...
what i'm wanting, I have a spread sheet of a phone bill, detailing number
called, date, duration, etc and i want excel to match the phone number
dialed
to a list of people in a seperate document/sheet, which is the best
formula
to use?





All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com