multiple logics

[joewray32]

I have a software called REVU where I can collect measurements off of a plan and export them into an excel sheets. I also have a previous excel sheet where I enter all my data. I want to be able to take the REVU file, upload it into my existing file and have my existing file search for certain data. below is a list of what I'm trying to do.

Existing File (default):
A B
1 10x10 0 ( I want the exiting file to automatically read the imported file, if 10x10 has 4, then i want it to return 4, if not, then return 0)
2 12x12 0
3 14x14 0


Imported File:
A B
1 10x10 4
2 12x12 0
3 14x14 6

I tried this =if(imported file!A1:A3="10x10",imported file!B4,0) but that isn't working and I get a #VALUE!

 

[Smitty]

Welcome to the Board!

As long as column A has unique values, you can use VLOOKUP.

=VLOOKUP(A1,'Imported File'!$A$1:$B$3,2,FALSE)

HTH,