Formula Help: If Sheet 1 A1 value exists in Sheet 2, find Sheet 1 C1 Thank you f

Question

Formula Help: If Sheet 1 A1 value exists in Sheet 2, find Sheet 1 C1

Thank you for looking at this. I am just not incredibly versed in some of the more complicated Excel formulas. I have played around with Vlookup and IF functions, but I think I am out of my league.

I am looking at 2 sets of data (pivot tables) in the same workbook on 2 separate sheets. Sheet 1 and 2 have a common data column. I want to create a formula in sheet 1 that does the following: If value in A1 (in Sheet 2) exists anywhere in Sheet 1, then pull the value of A3 from sheet 2.

I hope this makes sense. Let me know if you want more information.

Thanks for help !!

Explanation / Answer

Hi..

Assume that on sheet 1 you are using columns over to column E and rows down to row 304.

You could put a formula like this:

=IF(COUNTIF(Sheet1!$A$1:$E$304,Sheet2!$A$1)>0,Sheet2!$A$3,"");

if the number of rows used on Sheet1 is unknown/may grow over time, you could just reference the columns in use::

=IF(COUNTIF(Sheet1!$A:$E, Sheet2!$A$1)>0,Sheet2!$A$3, "");

Again, this assumes last column used on Sheet1 is E.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.