Solved Excel - if/then statements with VLookup

July 17, 2012 at 10:49:20
Specs: Macintosh
I have two spreadsheets that I need to gather information.
If Column A number matches Column B number (on a different spreadsheet) then insert the value of Column E on the second spreadsheet.

I think it will have to also include a VLookup


See More: Excel - if/then statements with VLookup

Report •


#1
July 17, 2012 at 11:09:09
✔ Best Answer
Why do you think it require VLOOKUP?

I don't think you do, but I'll admt that I don't I completely understand what you are trying to do.

re: then insert the value of Column E on the second spreadsheet.

Insert? Do you mean copy?

...on the second spreadsheet? Do you mean it should end up on the second spreadsheet or should be retrieved from the second spreadsheet?

Is this what you are looking for? This formula will return the value from Sheet2!E1 when Sheet1!A1 = Sheet2!B1

=IF(Sheet1!A1=Sheet2!B1,Sheet2!E1,"")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question