Spreadsheet: 67646d1268227002-complex-vlookup-forex
Sheet: Requirement

 | I would like this to find the rate dependant on the entries selected in the 3 blue boxes (which are list validated)
 | IE - If B5 = London UK and H5 = America then Lookup the value in B3 and find it in tab "1 June 2009 - LONDON" then go across 7 columns and return the data in that cell
 | This was working before but more jurisdiction codes have been added and therefore more than 7 IF statements are needed - here's a sample of what I had earlier before some other coutry codes were added so you get a jist of what I was working with.
 | Here is the criteria that I need this spreadsheet to follow:
 | If Cell B5 = | and H5 = | Then Lookup | In | Go across
 | London UK | London UK | B3 | 1 June 2009 - LONDON | 2 | columns | and return data in that cell
 | London UK | Regions UK | B3 | 1 June 2009 - LONDON | 2 | columns | and return data in that cell
 | London UK | America | B3 | 1 June 2009 - LONDON | 7 | columns | and return data in that cell
 | London UK | Dubai | B3 | 1 June 2009 - LONDON | 9 | columns | and return data in that cell
 | London UK | Asia Pacific | B3 | 1 June 2009 - LONDON | 10 | columns | and return data in that cell
 | London UK | Euro | B3 | 1 June 2009 - LONDON | 6 | columns | and return data in that cell
 | London UK | CNY | B3 | 1 June 2009 - LONDON | 8 | columns | and return data in that cell
 | London UK | SGD | B3 | 1 June 2009 - LONDON | 11 | columns | and return data in that cell
 | Dubai | London UK | B3 | 1 June 2009 - LONDON | 12 | columns | and return data in that cell
 | Dubai | Regions UK | B3 | 1 June 2009 - REGIONS | 12 | columns | and return data in that cell
 | Dubai | America | B3 | 1 June 2009 - REGIONS | 14 | columns | and return data in that cell
 | Dubai | Dubai | B3 | 1 June 2009 - REGIONS | 3 | columns | and return data in that cell
 | Dubai | Asia Pacific | B3 | 1 June 2009 - REGIONS | 13 | columns | and return data in that cell
 | Dubai | Euro | B3 | 1 June 2009 - REGIONS | 15 | columns | and return data in that cell
 | Dubai | CNY | B3 | 1 June 2009 - REGIONS | 16 | columns | and return data in that cell
 | Dubai | SGD | B3 | 1 June 2009 - REGIONS | 17 | columns | and return data in that cell
 | Asia Pacific | London UK | B3 | 1 June 2009 - LONDON | 18 | columns | and return data in that cell
 | Asia Pacific | Regions UK | B3 | 1 June 2009 - REGIONS | 18 | columns | and return data in that cell
 | Asia Pacific | America | B3 | 1 June 2009 - REGIONS | 21 | columns | and return data in that cell
 | Asia Pacific | Dubai | B3 | 1 June 2009 - REGIONS | 19 | columns | and return data in that cell
 | Asia Pacific | Asia Pacific | B3 | 1 June 2009 - REGIONS | 4 | columns | and return data in that cell
 | Asia Pacific | Euro | B3 | 1 June 2009 - REGIONS | 22 | columns | and return data in that cell
 | Asia Pacific | CNY | B3 | 1 June 2009 - REGIONS | 20 | columns | and return data in that cell
 | Asia Pacific | SGD | B3 | 1 June 2009 - REGIONS | 23 | columns | and return data in that cell
 | Singapore | London UK | B3 | 1 June 2009 - LONDON | 24 | columns | and return data in that cell
 | Singapore | Regions UK | B3 | 1 June 2009 - REGIONS | 24 | columns | and return data in that cell
 | Singapore | America | B3 | 1 June 2009 - REGIONS | 27 | columns | and return data in that cell
 | Singapore | Dubai | B3 | 1 June 2009 - REGIONS | 25 | columns | and return data in that cell
 | Singapore | Asia Pacific | B3 | 1 June 2009 - REGIONS | 29 | columns | and return data in that cell
 | Singapore | Euro | B3 | 1 June 2009 - REGIONS | 28 | columns | and return data in that cell
 | Singapore | CNY | B3 | 1 June 2009 - REGIONS | 26 | columns | and return data in that cell
 | Singapore | SGD | B3 | 1 June 2009 - REGIONS | 5 | columns | and return data in that cell
 | Whether the results shows in a separate sheet, in one cell or in a message box, I really don't mind - so long as the above is followed to the right details are returned
 | Obviously - any help is GREATLY appreciated!
 | Kind Regards
 | A very "Mind-Tired" Jamie Davies