Formula Help: If Sheet 1 A1 value exists in Sheet 2, find Sheet 1 C1 Thank you f
ID: 643226 • Letter: 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.