Lookup formula with 'IF'

Occasional Visitor
Hi all,

Hoping for help with the below in excel 2013

In Tab 2, i have 3 columns of data that is constantly changing, each with it's own heading based on 3 separate Pivot tables for the same data (Call the headings CITY, with the data being Licence Plate Numbers)

In Tab 1, in column B, is where i will enter the License number, and i need a Formula that will update column A to reflect which Heading this is under in Tab 2 I.E. search the 3 columns for a match, and tell me which heading it is under (wether it looks for that, or a value can be entered in the formula to return)

(And no I don't work in anything related to my examples, they purely are examples haha)
0 Replies