If match find then range offset value = "Bal"

**HaroonSid** · 01-13-2018, 03:31 AM

Hi,
I have a range sheet3.range("c20:c1000")
Match a value from above range in sheet4.range("c20:c1000")

For exapmle
If in sheet3.range("c20:c1000")
Activecell.value = 123
Then search this value in sheet4.range("c20:c1000") if match found then range.offser(0,3).value = "Bal"
I mean if string 123 found in sheet4.range("c40") then
Sheet4.range("c40").offset(0,3).value= "Bal"

Thank you

**Sintek** · 01-13-2018, 04:24 AM

Perhaps...

Please Login or Register  to view this content.

**davesexcel** · 01-13-2018, 05:03 AM

I believe I know what you mean, but attach a sample workbook anyway for times sake.

**HaroonSid** · 01-13-2018, 05:23 AM

Thank you very very much Sintek
its working as i need
thank you once again

@davesexcel i was on mobile that time, next time i will remain

If match find then range offset value = "Bal"

LinkBack

Thread Tools

Rate This Thread

Display

If match find then range offset value = "Bal"

Re: If match find then range offset value = "Bal"

Re: If match find then range offset value = "Bal"

Re: If match find then range offset value = "Bal"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If header and Col "A" match in both sheets then offset and put "1"

Using "index", "match", "min", "abs", to find the closest value in multiple criteria

Find/Match records, offset to row, enter "x"

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

[SOLVED] If Cell in column = "Y" then with offset (0, 1).value match to sheet range A3:A return ...

[SOLVED] Variable "sheet-name" and "range-name" wanted in INDEX/MATCH-function

How to Select a relative range with Using "Find" and Offset()

Bookmarks

Bookmarks

Posting Permissions