<<Any further ideas?

No. Your choice. To use VLOOKUP you will need to swap columns A and B to
facilitate the LOOKUP. Alternatively, you could replicate column A after
column B. You could do that with a formula; in cell C1 put the formula =A1
and drag down.

Not sure what you are trying to achieve ... intellectual exercise ?

Other than that, no, no ideas. The solution offered works.

Regards

Trevor


"pinehead" wrote in
message ...

Thank you for your response, however i'm attempting to do this example
withonly certain formulas in use.
My goal is to only use max,min,count,countif,sum,sumif,if,average or
vlookup
Any further ideas?

Thank you
Anthony


--
pinehead
------------------------------------------------------------------------
pinehead's Profile:
http://www.excelforum.com/member.php...o&userid=31721
View this thread: http://www.excelforum.com/showthread...hreadid=514291