Pulling matching data from separate worksheets

[Coquette]

I have a quickbooks report that has an account code "dot" accoun
description combined in one cell. My boss has a report grouped by typ
and alphabetically, with monthly data for the fiscal year. I would lik
to have a formula that looks at the account code in her spreadsheet
finds it on the quickbooks version, and pulls the value of the mont
into her spreadsheet.

E.g. Quickbooks
July
August
| 41600· Postage 35.02 40.04

Fiscal Report

Postage | 41600 ='quickbooks'xxxxxxx

Please tell me how to have it find the 41600 in the cell that ha
numbers and characters and pull it into the fiscal report for the sam
month

 

[Bernie Deitrick]

Coquette,

I believe it would be necessary to import the quickbooks information into a
spreadsheet and use Data | Text to columns.. to spread it out into separate
cells. Then you would simply use a VLOOKUP to extract the required data.

HTH,
Bernie
MS Excel MVP

 

[Coquette]

Bernie,

Thank you for responding so quickly. I tried to find how to impor
data directly into excel from quickbooks, cannot find it. I a
currently exporting the quickbooks report to excel, but cannot figur
out how to make that quickbooks report a data source the perform th
split you've suggested. Can you help?

Thanks,

Coquett

 

[Bernie Deitrick]

Coquette,

I don't have quickbooks, but if you can export the report to Excel, simply
open the file after you have exported it. Then you can do anything you want
with the data.

HTH,
Bernie
MS Excel MVP