W

#### williamsabbie

I'm trying to work out how to create a formula.

I need it to do a hlookup, and then a vlookup, but only in th

particular range.

I want to lookup the date in row 1,

then the kid, bringing back the number in the next column.

So along the top will be ID Number | Date

Then the columns will have IDs in first column the a value in the next

Example- 201201 along 1:1. Then lookup C54321, should bring back 7

kid |201201

D12345 |1

C54321 |7

A6789 |5

B1234 |3

C54322 |1

But i only want it to search the 2 columns corresponding to the dat

searched.

The data cannot be amended so I have to stick with this layout.

Any ideas?

Thanks in advanc