Return Value to Textboxes based on 2 criterias

[Khanzaki]

Respected members;
I currently have a code which enables me to retrieve data from sheet1 based on value in combo box rec2 ;
However I am looking for a way that will enable me to fetch values based on one additional criteria ie if column A or Range("A:A") to contains text "NEW"

Please Login or Register  to view this content.

Basically two criteria
!."NEW
2. rec2.value


Thanks for reading

[mjr veverka]

Attach a sample data file - maximum of several dozen lines of data, no more.
The data should be anonymized to maintain the confidentiality of real data.

[protonLeah]

Please Login or Register  to view this content.

[Sintek]

@ protonLeah
What happens if The first found - as per match - rec2 does not have "NEW" in Col A but "OLD" or something else...

This should work...No sample file so untested...

Please Login or Register  to view this content.

[Khanzaki]

@sintek sir !
Tried your method and it worked Thankyou so much ; uploading a sample file
@protonleah @mjr veverka Thankyou to you guys for your time !

[Sintek]

@sintek sir !
Tried your method and it worked

Glad you got it sorted...