Search code examples
excelexcel-2013

Excel: How to have an IF function return the value of the cell from another sheet

This is sort of a carry on from my previous question. I have a sheet named Car Search which returns the details of a car from the Raw Data sheet when the Car ID is entered (see image 1).

I would like the Notes column to return what is in the Raw Data sheet in that specific cell. This is dynamic; so if the cell was F561, then I would like it to return that exact cell.

So for example, when I enter the Car ID '2613' into the Car Search sheet, I would like column E5 to return the value of the specific cell in the Raw Data tab. (Currently, that cell is F5 which is 'here2').

Is there a formula that can do this? Or am I missing something in the current formula?

My current formula is this: =IF(INDEX('Raw Data'!E:F,MATCH($B$3,'Raw Data'!A:A,0),MATCH(E2,'Raw Data'!1:1,0))="","")

Car Search sheet Raw data sheet

Any help appreciated :)

Solution

  • Try this untested formula:

    =""&INDEX('Raw Data'!$F:$F,MATCH($B$3,'Raw Data'!$A:$A,0))