Look up and compare data in the same formula.

**gcastilleja** · 05-05-2009, 03:25 PM

Hi Guys, once again i'm asking for your help:
(Excel 2003) I have two sheets, named "source" and "target", in "Target" i have data to be compared columns A to E, i want to look up if the number 147 (just as example) is in a range of data in "source", if it is, then compare A to C and if it is equal then return E. i hope you can help me you have an answer on this. Is for my job, thank you very much Guys

**NBVC** · 05-05-2009, 03:42 PM

An example spreadsheet uploaded here would help.

**split_atom18** · 05-05-2009, 04:51 PM

I am totally guessing but made this quick, I hope it gives you a thought or an idea since like posted above, we need an example.

Hope this helps,

Dan

**gcastilleja** · 05-05-2009, 05:54 PM

First of all, thank you very much for your responses, thanks Dan and at our moderator NBVC. I'm sorry but now my problem is between files, same problem, but instead of lookin up trough spread sheets is in between two files, i attach an example of that. Thank you very much again. BTW both files are for the same example

**NBVC** · 05-05-2009, 06:24 PM

Place this formula in H4 of workbook A.xls

=INDEX('[A.xls]Sheet1'!H$4:H$10,MATCH(1,('[A.xls]Sheet1'!$D$4:$D$10=$D4)*('[A.xls]Sheet1'!$E$4:$E$10=$E4)*('[A.xls]Sheet1'!$G$4:$G$10=$G4),0))

Then while the cell is active (cursor is in cell), hold the CTRL and SHIFT keys down and hit ENTER.. you will see { } brackets appear. Then copy the formula to the right and down the rows...

I hope this is what you needed.