complex formulas

  • Thread starter Thread starter Alyssa Wiener
  • Start date Start date
A

Alyssa Wiener

I'm trying to pull information from different
spreadsheets in the same workbook and combine them into
one spreadsheet.

I have a list of merchant ID numbers in one row on each
spreadsheet. There is a list of dollar amounts in
another row on each spreadsheet as well. Not all the
sheets have the same list; some have new companies added
each month, and some drop off.

I need a way to match merchant ID's in each sheet and
pull the dollar amounts.

this is the formula I have come up with when I specify
which cell all the information is in: =IF(Sheet1!
B7=Sheet2!B5, Sheet2!D5, "no match")

Since the sheets do not always contain the same
information, this won't work.

Help!!! Anyone?

Thanks in advance.
Alyssa
 
Alyssa Wiener said:
I'm trying to pull information from different
spreadsheets in the same workbook and combine them into
one spreadsheet. ....
I need a way to match merchant ID's in each sheet and
pull the dollar amounts.
Click to expand...
....

Not enough details to give detailed help, but you need to start by
familiarizing yourself with the MATCH, HLOOKUP and VLOOKUP functions.
They're in online help.
 
Back
Top