can vlookup solve this?

[cflyte]

<SOLVED> Hello, very new to spreadsheets - only have a basic understanding so far.
However, although this may be a long shot, I am hoping there is a solution.

I have attached a screen capture image which hopefully will explain my dilemma better than trying to describe it here.

Kind regards

[dilipandey]

Hi cflyte,

welcome to the forum.
You can use Randbetween function for column B
And after this you can use vlookup function in column G.

In case of any issue, upload the sample workbook not image Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[cflyte]

Thankyou for your reply and assistance, sir.
Much appreciated.

Kind regards

Hi cflyte,

welcome to the forum.
You can use Randbetween function for column B
And after this you can use vlookup function in column G.

In case of any issue, upload the sample workbook not image Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[dilipandey]

Cheers

Suggest you to mark this thread as [SOLVED].. Thx.


Regards,
DILIPandey
<click on below * if this helps>

[cflyte]

could you tell me how to do that?
I can't see any link to do this.

Tkx
Kind regards

[dilipandey]

Okay.. as I mentioned in my post #2 :-

In case of any issue, upload the sample workbook not image Thanks.

Regards,
DILIPandey
<click on below * if this helps>

[dilipandey]

Thanks for the heads up Dredwolf

Hi cflyte,

If you mean "How to mark this thread as solved", below is what I found in forum rules :-

If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

http://www.excelforum.com/forum-rule...rum-rules.html



Regards,
DILIPandey
<click on below * if this helps>