A function that is both H/VLookup!

zo2o · 07-21-2010, 07:57 PM

SOLVED!

Thanks for your time all

xxx

**Ron Coderre** · 07-21-2010, 08:07 PM

I'm confident we can help...but the table you posted a picture of makes little sense.
Can you post an Excel file with a better structured table, some sample data, and the values you want returned based on that data?

**martindwilson** · 07-21-2010, 08:15 PM

why not post a workbook?

zo2o · 07-21-2010, 08:27 PM

see above

**Ron Coderre** · 07-21-2010, 08:32 PM

Is there a reason you aren't posting a sample workbook?

zo2o · 07-21-2010, 08:34 PM

Thanks, hope I can be of use sometime!

**royUK** · 07-22-2010, 04:02 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Please don't bother posting again if you intend wasting our members' valuable time