Searching 2 values to assign a value

[john01]

Hi everyone,

I requeire some help regards my database i need some help finding a suitable formula to help me assign a value by which it searches a group of values for example:

(Sheet 1 / Main database)

From | To | Grid
--------------------------------------------------------
Melbourne Airport | Broadmedows | 3
Melbourne Airport | Kilsyth | 6
Melbourne Airport | Reservoir | 7
Broadmedows | Coolaroo | 2
Broadmedows | Kilsyth | 5
Broadmedows | Reservoir | 4

(Sheet 2 / Calculating sheet)

Ok this is what i mean it would search the "From" row and the "To" row and then assign the appropriate "Grid" number all that will be done in the 2nd sheet.

If more information is needed let me know.

Thank you for any replies.

[VBA Noob]

Hi,

I assume you type in the two locations and want the result to appear in sheet 2.

If this is the case you could try the below

It's an array so needs to be entered with Ctrl + Shift + Enter

=INDEX('Main database'!C2:C7,MATCH('Calculating sheet'!A2&'Calculating sheet'!B2,'Main database'!A2:A7&'Main database'!B2:B7,0))

or using sheet names

=INDEX(Sheet1!C2:C7,MATCH(Sheet2!A2&Sheet2!B2,Sheet1!A2:A7&Sheet1!B2:B7,0))

VBA Noob

[john01]

Thx m8 it worked like a charm :D

[VBA Noob]

No problem

VBA Noob