How to use vba to get data from table on another sheet in same workbook

[ndtsteve]

Hi there.

I am hoping that someone can point me a the right direction with the attached file. I'm new to vba and struggling with coding as this is 'just a hobby' of mine that I play around with.

I want to get to where selecting values in 2 different columns on sheet 1 will go to sheet 2 and select the corresponding value from a table and display that vale back on sheet 1. Hopefully the attachment will make it clearer

I could probably do it a very long winded way:
if cell = A and cell = 3 then value = A3
if cell = A and cell = 5 then value = A5.......but I have many columns and rows to work with and this would take me ages. I'm sure there must be an easier way, I just don't know it.......yet!

Thanks in advance.

[tkowal]

Example-vlookup.xlsx

See if this helps ...

[ndtsteve]

Thankyou very much tkowal, looks like this will work fine.
Should be pretty easy for me to expand on this and make it work for me.