Hi, I am unable to find the errors in my formula. Here is what I need to do:
Sheet 1 has values in row A2:W2 and column B
Sheet 2: Needs to match the values located in row A2:W2 and column B with the respective values in sheet 1.
The formula will be used in sheet 2. After it matches the values as described above it looks at the values in the corresponding cells in sheet 1 (eg sheet 1, E10) and multiplies it by the number located in sheet 2 row 3 (eg E3).
Thanks you for your help
Bookmarks