Hi,
I have a data in Sheet "List". In column G, I have numberic values. In sheet "Band", I have types of Band in column N (Band_1), P (Band_2), R (Band_3) and T (Band_4).
I Sheet List against the numberic values in G, Want to insert band (number bracket) in resctive column i.e, J, L, N and Q
Please refer sheet "Result" for final output.
If you adjust your band table to use the lower limit as a lookup value, you can use VLOOKUP like this:
See the attached.
Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Hi,
Thank you very much for your reply.
Instead of Formula I, Need in a VB Code.
Coz I need to add the same in my other VB code.
the Code should run till the lsat row of Serial number mentioned on Column A.
Last edited by saravanan1981; 10-08-2019 at 10:36 AM.
OK. With the book I attached earlier, add this code:
WBDPlease Login or Register to view this content.
It shows in error in below line
Cells(thisRow, thisCol).Value = Application.VLookup(Cells(thisRow, "G").Value, Range(Cells(1, thisCol).Value), 2, True)
What is the error? When it errors, use Ctrl+G to bring up the immediate window and type this:
Hit return and tell me what it shows.Please Login or Register to view this content.
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks