Forum Discussion
Formula help
Hi community struggling to get my head round this... I have 2 worksheets and need a formula for the following: If column A (Customer) on Sheet 1 matches Customer on Column A on Sheet 2 then ...
OliverScheurich thanks for the formulas but still struggling as i get a REF in the B1 Sheet 1 cell?
Forgot to mention i have headings in on both sheets:
SHEET 1
SHEET 2:
So, want to match 'Customer' in Sheet 1 with 'Customer' in Sheet 2 and if a match copy the data in Sheet 2 'Client Release' (G) to Sheet 1 'Client Release' 'B'
Hope you can advise further
Thanks
In cell B2 of Sheet 1:
=INDEX('Sheet 2'!$G$2:$G$1000,MATCH('Sheet 1'!A2,'Sheet 2'!$A$2:$A$1000,0))
or
=VLOOKUP('Sheet 1'!A2,'Sheet 2'!$A$2:$G$1000,7,0)
If the data in the sheets starts in row 2 and if you want to return the results from column G of Sheet 2 you can apply one of the above formulas. The above formulas work if you don't have dynamic tables.
From your screenshots i can't tell if you work with dynamic tables. However if you use dynamic table you have to apply a formula like this
=INDEX(Tabelle3[client release],MATCH([@customer],Tabelle3[customer],0))
where you must replace Tabelle3 with the name of your dynamic table in Sheet 2.